pgLatLon: 4489b4d7d9c8 latlon--0.2--0.3.sql

pgLatLon

view latlon--0.2--0.3.sql @ 13:4489b4d7d9c8

Updated manual installation instructions in README files to match version 0.3

author	jbe
date	Fri Sep 02 14:31:58 2016 +0200 (2016-09-02)
parents	b4ec52e7e888
children

line source

2 CREATE OR REPLACE FUNCTION ekey_point_in_dummy(cstring)

3 RETURNS ekey_point

4 LANGUAGE C IMMUTABLE STRICT

5 AS '$libdir/latlon-v0003', 'pgl_notimpl';

7 CREATE OR REPLACE FUNCTION ekey_point_out_dummy(ekey_point)

8 RETURNS cstring

9 LANGUAGE C IMMUTABLE STRICT

10 AS '$libdir/latlon-v0003', 'pgl_notimpl';

12 CREATE OR REPLACE FUNCTION ekey_area_in_dummy(cstring)

13 RETURNS ekey_area

14 LANGUAGE C IMMUTABLE STRICT

15 AS '$libdir/latlon-v0003', 'pgl_notimpl';

17 CREATE OR REPLACE FUNCTION ekey_area_out_dummy(ekey_area)

18 RETURNS cstring

19 LANGUAGE C IMMUTABLE STRICT

20 AS '$libdir/latlon-v0003', 'pgl_notimpl';

22 CREATE OR REPLACE FUNCTION epoint_in(cstring)

23 RETURNS epoint

24 LANGUAGE C IMMUTABLE STRICT

25 AS '$libdir/latlon-v0003', 'pgl_epoint_in';

27 CREATE OR REPLACE FUNCTION ebox_in(cstring)

28 RETURNS ebox

29 LANGUAGE C IMMUTABLE STRICT

30 AS '$libdir/latlon-v0003', 'pgl_ebox_in';

32 CREATE OR REPLACE FUNCTION ecircle_in(cstring)

33 RETURNS ecircle

34 LANGUAGE C IMMUTABLE STRICT

35 AS '$libdir/latlon-v0003', 'pgl_ecircle_in';

37 CREATE OR REPLACE FUNCTION ecluster_in(cstring)

38 RETURNS ecluster

39 LANGUAGE C IMMUTABLE STRICT

40 AS '$libdir/latlon-v0003', 'pgl_ecluster_in';

42 CREATE OR REPLACE FUNCTION epoint_out(epoint)

43 RETURNS cstring

44 LANGUAGE C IMMUTABLE STRICT

45 AS '$libdir/latlon-v0003', 'pgl_epoint_out';

47 CREATE OR REPLACE FUNCTION ebox_out(ebox)

48 RETURNS cstring

49 LANGUAGE C IMMUTABLE STRICT

50 AS '$libdir/latlon-v0003', 'pgl_ebox_out';

52 CREATE OR REPLACE FUNCTION ecircle_out(ecircle)

53 RETURNS cstring

54 LANGUAGE C IMMUTABLE STRICT

55 AS '$libdir/latlon-v0003', 'pgl_ecircle_out';

57 CREATE OR REPLACE FUNCTION ecluster_out(ecluster)

58 RETURNS cstring

59 LANGUAGE C IMMUTABLE STRICT

60 AS '$libdir/latlon-v0003', 'pgl_ecluster_out';

62 CREATE OR REPLACE FUNCTION epoint_recv(internal)

63 RETURNS epoint

64 LANGUAGE C IMMUTABLE STRICT

65 AS '$libdir/latlon-v0003', 'pgl_epoint_recv';

67 CREATE OR REPLACE FUNCTION ebox_recv(internal)

68 RETURNS ebox

69 LANGUAGE C IMMUTABLE STRICT

70 AS '$libdir/latlon-v0003', 'pgl_ebox_recv';

72 CREATE OR REPLACE FUNCTION ecircle_recv(internal)

73 RETURNS ecircle

74 LANGUAGE C IMMUTABLE STRICT

75 AS '$libdir/latlon-v0003', 'pgl_ecircle_recv';

77 CREATE OR REPLACE FUNCTION epoint_send(epoint)

78 RETURNS bytea

79 LANGUAGE C IMMUTABLE STRICT

80 AS '$libdir/latlon-v0003', 'pgl_epoint_send';

82 CREATE OR REPLACE FUNCTION ebox_send(ebox)

83 RETURNS bytea

84 LANGUAGE C IMMUTABLE STRICT

85 AS '$libdir/latlon-v0003', 'pgl_ebox_send';

87 CREATE OR REPLACE FUNCTION ecircle_send(ecircle)

88 RETURNS bytea

89 LANGUAGE C IMMUTABLE STRICT

90 AS '$libdir/latlon-v0003', 'pgl_ecircle_send';

92 CREATE OR REPLACE FUNCTION epoint_btree_lt(epoint, epoint)

93 RETURNS boolean

94 LANGUAGE C IMMUTABLE STRICT

95 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_lt';

97 CREATE OR REPLACE FUNCTION epoint_btree_le(epoint, epoint)

98 RETURNS boolean

99 LANGUAGE C IMMUTABLE STRICT

100 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_le';

101

102 CREATE OR REPLACE FUNCTION epoint_btree_eq(epoint, epoint)

103 RETURNS boolean

104 LANGUAGE C IMMUTABLE STRICT

105 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_eq';

106

107 CREATE OR REPLACE FUNCTION epoint_btree_ne(epoint, epoint)

108 RETURNS boolean

109 LANGUAGE C IMMUTABLE STRICT

110 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_ne';

111

112 CREATE OR REPLACE FUNCTION epoint_btree_ge(epoint, epoint)

113 RETURNS boolean

114 LANGUAGE C IMMUTABLE STRICT

115 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_ge';

116

117 CREATE OR REPLACE FUNCTION epoint_btree_gt(epoint, epoint)

118 RETURNS boolean

119 LANGUAGE C IMMUTABLE STRICT

120 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_gt';

121

122 CREATE OR REPLACE FUNCTION epoint_btree_cmp(epoint, epoint)

123 RETURNS int4

124 LANGUAGE C IMMUTABLE STRICT

125 AS '$libdir/latlon-v0003', 'pgl_btree_epoint_cmp';

126

127 CREATE OR REPLACE FUNCTION ebox_btree_lt(ebox, ebox)

128 RETURNS boolean

129 LANGUAGE C IMMUTABLE STRICT

130 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_lt';

131

132 CREATE OR REPLACE FUNCTION ebox_btree_le(ebox, ebox)

133 RETURNS boolean

134 LANGUAGE C IMMUTABLE STRICT

135 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_le';

136

137 CREATE OR REPLACE FUNCTION ebox_btree_eq(ebox, ebox)

138 RETURNS boolean

139 LANGUAGE C IMMUTABLE STRICT

140 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_eq';

141

142 CREATE OR REPLACE FUNCTION ebox_btree_ne(ebox, ebox)

143 RETURNS boolean

144 LANGUAGE C IMMUTABLE STRICT

145 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_ne';

146

147 CREATE OR REPLACE FUNCTION ebox_btree_ge(ebox, ebox)

148 RETURNS boolean

149 LANGUAGE C IMMUTABLE STRICT

150 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_ge';

151

152 CREATE OR REPLACE FUNCTION ebox_btree_gt(ebox, ebox)

153 RETURNS boolean

154 LANGUAGE C IMMUTABLE STRICT

155 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_gt';

156

157 CREATE OR REPLACE FUNCTION ebox_btree_cmp(ebox, ebox)

158 RETURNS int4

159 LANGUAGE C IMMUTABLE STRICT

160 AS '$libdir/latlon-v0003', 'pgl_btree_ebox_cmp';

161

162 CREATE OR REPLACE FUNCTION ecircle_btree_lt(ecircle, ecircle)

163 RETURNS boolean

164 LANGUAGE C IMMUTABLE STRICT

165 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_lt';

166

167 CREATE OR REPLACE FUNCTION ecircle_btree_le(ecircle, ecircle)

168 RETURNS boolean

169 LANGUAGE C IMMUTABLE STRICT

170 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_le';

171

172 CREATE OR REPLACE FUNCTION ecircle_btree_eq(ecircle, ecircle)

173 RETURNS boolean

174 LANGUAGE C IMMUTABLE STRICT

175 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_eq';

176

177 CREATE OR REPLACE FUNCTION ecircle_btree_ne(ecircle, ecircle)

178 RETURNS boolean

179 LANGUAGE C IMMUTABLE STRICT

180 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_ne';

181

182 CREATE OR REPLACE FUNCTION ecircle_btree_ge(ecircle, ecircle)

183 RETURNS boolean

184 LANGUAGE C IMMUTABLE STRICT

185 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_ge';

186

187 CREATE OR REPLACE FUNCTION ecircle_btree_gt(ecircle, ecircle)

188 RETURNS boolean

189 LANGUAGE C IMMUTABLE STRICT

190 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_gt';

191

192 CREATE OR REPLACE FUNCTION ecircle_btree_cmp(ecircle, ecircle)

193 RETURNS int4

194 LANGUAGE C IMMUTABLE STRICT

195 AS '$libdir/latlon-v0003', 'pgl_btree_ecircle_cmp';

196

197 CREATE OR REPLACE FUNCTION cast_epoint_to_ebox(epoint)

198 RETURNS ebox

199 LANGUAGE C IMMUTABLE STRICT

200 AS '$libdir/latlon-v0003', 'pgl_epoint_to_ebox';

201

202 CREATE OR REPLACE FUNCTION cast_epoint_to_ecircle(epoint)

203 RETURNS ecircle

204 LANGUAGE C IMMUTABLE STRICT

205 AS '$libdir/latlon-v0003', 'pgl_epoint_to_ecircle';

206

207 CREATE OR REPLACE FUNCTION cast_epoint_to_ecluster(epoint)

208 RETURNS ecluster

209 LANGUAGE C IMMUTABLE STRICT

210 AS '$libdir/latlon-v0003', 'pgl_epoint_to_ecluster';

211

212 CREATE OR REPLACE FUNCTION cast_ebox_to_ecluster(ebox)

213 RETURNS ecluster

214 LANGUAGE C IMMUTABLE STRICT

215 AS '$libdir/latlon-v0003', 'pgl_ebox_to_ecluster';

216

217 CREATE OR REPLACE FUNCTION epoint(float8, float8)

218 RETURNS epoint

219 LANGUAGE C IMMUTABLE STRICT

220 AS '$libdir/latlon-v0003', 'pgl_create_epoint';

221

222 CREATE OR REPLACE FUNCTION empty_ebox()

223 RETURNS ebox

224 LANGUAGE C IMMUTABLE STRICT

225 AS '$libdir/latlon-v0003', 'pgl_create_empty_ebox';

226

227 CREATE OR REPLACE FUNCTION ebox(float8, float8, float8, float8)

228 RETURNS ebox

229 LANGUAGE C IMMUTABLE STRICT

230 AS '$libdir/latlon-v0003', 'pgl_create_ebox';

231

232 CREATE OR REPLACE FUNCTION ebox(epoint, epoint)

233 RETURNS ebox

234 LANGUAGE C IMMUTABLE STRICT

235 AS '$libdir/latlon-v0003', 'pgl_create_ebox_from_epoints';

236

237 CREATE OR REPLACE FUNCTION ecircle(float8, float8, float8)

238 RETURNS ecircle

239 LANGUAGE C IMMUTABLE STRICT

240 AS '$libdir/latlon-v0003', 'pgl_create_ecircle';

241

242 CREATE OR REPLACE FUNCTION ecircle(epoint, float8)

243 RETURNS ecircle

244 LANGUAGE C IMMUTABLE STRICT

245 AS '$libdir/latlon-v0003', 'pgl_create_ecircle_from_epoint';

246

247 CREATE OR REPLACE FUNCTION latitude(epoint)

248 RETURNS float8

249 LANGUAGE C IMMUTABLE STRICT

250 AS '$libdir/latlon-v0003', 'pgl_epoint_lat';

251

252 CREATE OR REPLACE FUNCTION longitude(epoint)

253 RETURNS float8

254 LANGUAGE C IMMUTABLE STRICT

255 AS '$libdir/latlon-v0003', 'pgl_epoint_lon';

256

257 CREATE OR REPLACE FUNCTION min_latitude(ebox)

258 RETURNS float8

259 LANGUAGE C IMMUTABLE STRICT

260 AS '$libdir/latlon-v0003', 'pgl_ebox_lat_min';

261

262 CREATE OR REPLACE FUNCTION max_latitude(ebox)

263 RETURNS float8

264 LANGUAGE C IMMUTABLE STRICT

265 AS '$libdir/latlon-v0003', 'pgl_ebox_lat_max';

266

267 CREATE OR REPLACE FUNCTION min_longitude(ebox)

268 RETURNS float8

269 LANGUAGE C IMMUTABLE STRICT

270 AS '$libdir/latlon-v0003', 'pgl_ebox_lon_min';

271

272 CREATE OR REPLACE FUNCTION max_longitude(ebox)

273 RETURNS float8

274 LANGUAGE C IMMUTABLE STRICT

275 AS '$libdir/latlon-v0003', 'pgl_ebox_lon_max';

276

277 CREATE OR REPLACE FUNCTION center(ecircle)

278 RETURNS epoint

279 LANGUAGE C IMMUTABLE STRICT

280 AS '$libdir/latlon-v0003', 'pgl_ecircle_center';

281

282 CREATE OR REPLACE FUNCTION radius(ecircle)

283 RETURNS float8

284 LANGUAGE C IMMUTABLE STRICT

285 AS '$libdir/latlon-v0003', 'pgl_ecircle_radius';

286

287 CREATE OR REPLACE FUNCTION epoint_ebox_overlap_proc(epoint, ebox)

288 RETURNS boolean

289 LANGUAGE C IMMUTABLE STRICT

290 AS '$libdir/latlon-v0003', 'pgl_epoint_ebox_overlap';

291

292 CREATE OR REPLACE FUNCTION epoint_ecircle_overlap_proc(epoint, ecircle)

293 RETURNS boolean

294 LANGUAGE C IMMUTABLE STRICT

295 AS '$libdir/latlon-v0003', 'pgl_epoint_ecircle_overlap';

296

297 CREATE OR REPLACE FUNCTION epoint_ecluster_overlap_proc(epoint, ecluster)

298 RETURNS boolean

299 LANGUAGE C IMMUTABLE STRICT

300 AS '$libdir/latlon-v0003', 'pgl_epoint_ecluster_overlap';

301

302 CREATE OR REPLACE FUNCTION epoint_ecluster_may_overlap_proc(epoint, ecluster)

303 RETURNS boolean

304 LANGUAGE C IMMUTABLE STRICT

305 AS '$libdir/latlon-v0003', 'pgl_epoint_ecluster_may_overlap';

306

307 CREATE OR REPLACE FUNCTION ebox_overlap_proc(ebox, ebox)

308 RETURNS boolean

309 LANGUAGE C IMMUTABLE STRICT

310 AS '$libdir/latlon-v0003', 'pgl_ebox_overlap';

311

312 CREATE OR REPLACE FUNCTION ebox_ecircle_may_overlap_proc(ebox, ecircle)

313 RETURNS boolean

314 LANGUAGE C IMMUTABLE STRICT

315 AS '$libdir/latlon-v0003', 'pgl_ebox_ecircle_may_overlap';

316

317 CREATE OR REPLACE FUNCTION ebox_ecluster_may_overlap_proc(ebox, ecluster)

318 RETURNS boolean

319 LANGUAGE C IMMUTABLE STRICT

320 AS '$libdir/latlon-v0003', 'pgl_ebox_ecluster_may_overlap';

321

322 CREATE OR REPLACE FUNCTION ecircle_overlap_proc(ecircle, ecircle)

323 RETURNS boolean

324 LANGUAGE C IMMUTABLE STRICT

325 AS '$libdir/latlon-v0003', 'pgl_ecircle_overlap';

326

327 CREATE OR REPLACE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster)

328 RETURNS boolean

329 LANGUAGE C IMMUTABLE STRICT

330 AS '$libdir/latlon-v0003', 'pgl_ecircle_ecluster_overlap';

331

332 CREATE OR REPLACE FUNCTION ecircle_ecluster_may_overlap_proc(ecircle, ecluster)

333 RETURNS boolean

334 LANGUAGE C IMMUTABLE STRICT

335 AS '$libdir/latlon-v0003', 'pgl_ecircle_ecluster_may_overlap';

336

337 CREATE OR REPLACE FUNCTION ecluster_may_overlap_proc(ecluster, ecluster)

338 RETURNS boolean

339 LANGUAGE C IMMUTABLE STRICT

340 AS '$libdir/latlon-v0003', 'pgl_ecluster_may_overlap';

341

342 CREATE OPERATOR &&+ (

343 leftarg = epoint,

344 rightarg = ecluster,

345 procedure = epoint_ecluster_may_overlap_proc,

346 commutator = &&+,

347 restrict = areasel,

348 join = areajoinsel

349 );

350

351 CREATE FUNCTION epoint_ecluster_may_overlap_commutator(ecluster, epoint)

352 RETURNS boolean

353 LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';

354

355 CREATE OPERATOR &&+ (

356 leftarg = ecluster,

357 rightarg = epoint,

358 procedure = epoint_ecluster_may_overlap_commutator,

359 commutator = &&+,

360 restrict = areasel,

361 join = areajoinsel

362 );

363

364 CREATE OPERATOR &&+ (

365 leftarg = ebox,

366 rightarg = ecircle,

367 procedure = ebox_ecircle_may_overlap_proc,

368 commutator = &&+,

369 restrict = areasel,

370 join = areajoinsel

371 );

372

373 CREATE FUNCTION ebox_ecircle_may_overlap_commutator(ecircle, ebox)

374 RETURNS boolean

375 LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';

376

377 CREATE OPERATOR &&+ (

378 leftarg = ecircle,

379 rightarg = ebox,

380 procedure = ebox_ecircle_may_overlap_commutator,

381 commutator = &&+,

382 restrict = areasel,

383 join = areajoinsel

384 );

385

386 CREATE OPERATOR &&+ (

387 leftarg = ebox,

388 rightarg = ecluster,

389 procedure = ebox_ecluster_may_overlap_proc,

390 commutator = &&+,

391 restrict = areasel,

392 join = areajoinsel

393 );

394

395 CREATE FUNCTION ebox_ecluster_may_overlap_commutator(ecluster, ebox)

396 RETURNS boolean

397 LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';

398

399 CREATE OPERATOR &&+ (

400 leftarg = ecluster,

401 rightarg = ebox,

402 procedure = ebox_ecluster_may_overlap_commutator,

403 commutator = &&+,

404 restrict = areasel,

405 join = areajoinsel

406 );

407

408 CREATE OPERATOR &&+ (

409 leftarg = ecircle,

410 rightarg = ecluster,

411 procedure = ecircle_ecluster_may_overlap_proc,

412 commutator = &&+,

413 restrict = areasel,

414 join = areajoinsel

415 );

416

417 CREATE FUNCTION ecircle_ecluster_may_overlap_commutator(ecluster, ecircle)

418 RETURNS boolean

419 LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';

420

421 CREATE OPERATOR &&+ (

422 leftarg = ecluster,

423 rightarg = ecircle,

424 procedure = ecircle_ecluster_may_overlap_commutator,

425 commutator = &&+,

426 restrict = areasel,

427 join = areajoinsel

428 );

429

430 CREATE OPERATOR &&+ (

431 leftarg = ecluster,

432 rightarg = ecluster,

433 procedure = ecluster_may_overlap_proc,

434 commutator = &&+,

435 restrict = areasel,

436 join = areajoinsel

437 );

438

439 CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint)

440 RETURNS float8

441 LANGUAGE C IMMUTABLE STRICT

442 AS '$libdir/latlon-v0003', 'pgl_epoint_distance';

443

444 CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)

445 RETURNS float8

446 LANGUAGE C IMMUTABLE STRICT

447 AS '$libdir/latlon-v0003', 'pgl_epoint_ecircle_distance';

448

449 CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)

450 RETURNS float8

451 LANGUAGE C IMMUTABLE STRICT

452 AS '$libdir/latlon-v0003', 'pgl_epoint_ecluster_distance';

453

454 CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle)

455 RETURNS float8

456 LANGUAGE C IMMUTABLE STRICT

457 AS '$libdir/latlon-v0003', 'pgl_ecircle_distance';

458

459 CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)

460 RETURNS float8

461 LANGUAGE C IMMUTABLE STRICT

462 AS '$libdir/latlon-v0003', 'pgl_ecircle_ecluster_distance';

463

464 CREATE OR REPLACE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal)

465 RETURNS boolean

466 LANGUAGE C STRICT

467 AS '$libdir/latlon-v0003', 'pgl_gist_consistent';

468

469 CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal)

470 RETURNS internal

471 LANGUAGE C STRICT

472 AS '$libdir/latlon-v0003', 'pgl_gist_union';

473

474 CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal)

475 RETURNS internal

476 LANGUAGE C STRICT

477 AS '$libdir/latlon-v0003', 'pgl_gist_compress_epoint';

478

479 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal)

480 RETURNS internal

481 LANGUAGE C STRICT

482 AS '$libdir/latlon-v0003', 'pgl_gist_compress_ecircle';

483

484 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal)

485 RETURNS internal

486 LANGUAGE C STRICT

487 AS '$libdir/latlon-v0003', 'pgl_gist_compress_ecluster';

488

489 CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal)

490 RETURNS internal

491 LANGUAGE C STRICT

492 AS '$libdir/latlon-v0003', 'pgl_gist_decompress';

493

494 CREATE OR REPLACE FUNCTION pgl_gist_penalty(internal, internal, internal)

495 RETURNS internal

496 LANGUAGE C STRICT

497 AS '$libdir/latlon-v0003', 'pgl_gist_penalty';

498

499 CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal)

500 RETURNS internal

501 LANGUAGE C STRICT

502 AS '$libdir/latlon-v0003', 'pgl_gist_picksplit';

503

504 CREATE OR REPLACE FUNCTION pgl_gist_same(internal, internal, internal)

505 RETURNS internal

506 LANGUAGE C STRICT

507 AS '$libdir/latlon-v0003', 'pgl_gist_same';

508

509 CREATE OR REPLACE FUNCTION pgl_gist_distance(internal, internal, smallint, oid)

510 RETURNS internal

511 LANGUAGE C STRICT

512 AS '$libdir/latlon-v0003', 'pgl_gist_distance';

513

514 DROP OPERATOR CLASS epoint_ops USING gist;

515 CREATE OPERATOR CLASS epoint_ops

516 DEFAULT FOR TYPE epoint USING gist AS

517 OPERATOR 11 = ,

518 OPERATOR 22 && (epoint, ebox),

519 OPERATOR 23 && (epoint, ecircle),

520 OPERATOR 24 && (epoint, ecluster),

521 OPERATOR 124 &&+ (epoint, ecluster),

522 OPERATOR 31 <-> (epoint, epoint) FOR ORDER BY float_ops,

523 OPERATOR 33 <-> (epoint, ecircle) FOR ORDER BY float_ops,

524 OPERATOR 34 <-> (epoint, ecluster) FOR ORDER BY float_ops,

525 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),

526 FUNCTION 2 pgl_gist_union(internal, internal),

527 FUNCTION 3 pgl_gist_compress_epoint(internal),

528 FUNCTION 4 pgl_gist_decompress(internal),

529 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),

530 FUNCTION 6 pgl_gist_picksplit(internal, internal),

531 FUNCTION 7 pgl_gist_same(internal, internal, internal),

532 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),

533 STORAGE ekey_point;

534

535 DROP OPERATOR CLASS ecircle_ops USING gist;

536 CREATE OPERATOR CLASS ecircle_ops

537 DEFAULT FOR TYPE ecircle USING gist AS

538 OPERATOR 13 = ,

539 OPERATOR 21 && (ecircle, epoint),

540 OPERATOR 122 &&+ (ecircle, ebox),

541 OPERATOR 23 && (ecircle, ecircle),

542 OPERATOR 24 && (ecircle, ecluster),

543 OPERATOR 124 &&+ (ecircle, ecluster),

544 OPERATOR 31 <-> (ecircle, epoint) FOR ORDER BY float_ops,

545 OPERATOR 33 <-> (ecircle, ecircle) FOR ORDER BY float_ops,

546 OPERATOR 34 <-> (ecircle, ecluster) FOR ORDER BY float_ops,

547 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),

548 FUNCTION 2 pgl_gist_union(internal, internal),

549 FUNCTION 3 pgl_gist_compress_ecircle(internal),

550 FUNCTION 4 pgl_gist_decompress(internal),

551 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),

552 FUNCTION 6 pgl_gist_picksplit(internal, internal),

553 FUNCTION 7 pgl_gist_same(internal, internal, internal),

554 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),

555 STORAGE ekey_area;

556

557 DROP OPERATOR CLASS ecluster_ops USING gist;

558 CREATE OPERATOR CLASS ecluster_ops

559 DEFAULT FOR TYPE ecluster USING gist AS

560 OPERATOR 21 && (ecluster, epoint),

561 OPERATOR 121 &&+ (ecluster, epoint),

562 OPERATOR 122 &&+ (ecluster, ebox),

563 OPERATOR 23 && (ecluster, ecircle),

564 OPERATOR 123 &&+ (ecluster, ecircle),

565 OPERATOR 124 &&+ (ecluster, ecluster),

566 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),

567 FUNCTION 2 pgl_gist_union(internal, internal),

568 FUNCTION 3 pgl_gist_compress_ecluster(internal),

569 FUNCTION 4 pgl_gist_decompress(internal),

570 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),

571 FUNCTION 6 pgl_gist_picksplit(internal, internal),

572 FUNCTION 7 pgl_gist_same(internal, internal, internal),

573 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),

574 STORAGE ekey_area;

575