pgLatLon: d8ac13006162 latlon--0.4--0.5.sql

pgLatLon

view latlon--0.4--0.5.sql @ 25:d8ac13006162

Added update script to version 0.6

author	jbe
date	Thu Sep 22 21:57:03 2016 +0200 (2016-09-22)
parents	8a8d6dc44337
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-v0005', '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-v0005', '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-v0005', '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-v0005', 'pgl_notimpl';

22 CREATE OR REPLACE FUNCTION epoint_in(cstring)

23 RETURNS epoint

24 LANGUAGE C IMMUTABLE STRICT

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

27 CREATE OR REPLACE FUNCTION ebox_in(cstring)

28 RETURNS ebox

29 LANGUAGE C IMMUTABLE STRICT

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

32 CREATE OR REPLACE FUNCTION ecircle_in(cstring)

33 RETURNS ecircle

34 LANGUAGE C IMMUTABLE STRICT

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

37 CREATE OR REPLACE FUNCTION ecluster_in(cstring)

38 RETURNS ecluster

39 LANGUAGE C IMMUTABLE STRICT

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

42 CREATE OR REPLACE FUNCTION epoint_out(epoint)

43 RETURNS cstring

44 LANGUAGE C IMMUTABLE STRICT

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

47 CREATE OR REPLACE FUNCTION ebox_out(ebox)

48 RETURNS cstring

49 LANGUAGE C IMMUTABLE STRICT

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

52 CREATE OR REPLACE FUNCTION ecircle_out(ecircle)

53 RETURNS cstring

54 LANGUAGE C IMMUTABLE STRICT

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

57 CREATE OR REPLACE FUNCTION ecluster_out(ecluster)

58 RETURNS cstring

59 LANGUAGE C IMMUTABLE STRICT

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

62 CREATE OR REPLACE FUNCTION epoint_recv(internal)

63 RETURNS epoint

64 LANGUAGE C IMMUTABLE STRICT

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

67 CREATE OR REPLACE FUNCTION ebox_recv(internal)

68 RETURNS ebox

69 LANGUAGE C IMMUTABLE STRICT

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

72 CREATE OR REPLACE FUNCTION ecircle_recv(internal)

73 RETURNS ecircle

74 LANGUAGE C IMMUTABLE STRICT

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

77 CREATE OR REPLACE FUNCTION epoint_send(epoint)

78 RETURNS bytea

79 LANGUAGE C IMMUTABLE STRICT

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

82 CREATE OR REPLACE FUNCTION ebox_send(ebox)

83 RETURNS bytea

84 LANGUAGE C IMMUTABLE STRICT

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

87 CREATE OR REPLACE FUNCTION ecircle_send(ecircle)

88 RETURNS bytea

89 LANGUAGE C IMMUTABLE STRICT

90 AS '$libdir/latlon-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', 'pgl_create_epoint';

221

222 CREATE OR REPLACE FUNCTION empty_ebox()

223 RETURNS ebox

224 LANGUAGE C IMMUTABLE STRICT

225 AS '$libdir/latlon-v0005', '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-v0005', 'pgl_create_ebox';

231

232 CREATE OR REPLACE FUNCTION ebox(epoint, epoint)

233 RETURNS ebox

234 LANGUAGE C IMMUTABLE STRICT

235 AS '$libdir/latlon-v0005', '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-v0005', 'pgl_create_ecircle';

241

242 CREATE OR REPLACE FUNCTION ecircle(epoint, float8)

243 RETURNS ecircle

244 LANGUAGE C IMMUTABLE STRICT

245 AS '$libdir/latlon-v0005', '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-v0005', 'pgl_epoint_lat';

251

252 CREATE OR REPLACE FUNCTION longitude(epoint)

253 RETURNS float8

254 LANGUAGE C IMMUTABLE STRICT

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

256

257 CREATE OR REPLACE FUNCTION min_latitude(ebox)

258 RETURNS float8

259 LANGUAGE C IMMUTABLE STRICT

260 AS '$libdir/latlon-v0005', '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-v0005', '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-v0005', '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-v0005', 'pgl_ebox_lon_max';

276

277 CREATE OR REPLACE FUNCTION center(ecircle)

278 RETURNS epoint

279 LANGUAGE C IMMUTABLE STRICT

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

281

282 CREATE OR REPLACE FUNCTION radius(ecircle)

283 RETURNS float8

284 LANGUAGE C IMMUTABLE STRICT

285 AS '$libdir/latlon-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', '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-v0005', 'pgl_ecircle_ecluster_may_overlap';

336

337 CREATE OR REPLACE FUNCTION ecluster_overlap_proc(ecluster, ecluster)

338 RETURNS boolean

339 LANGUAGE C IMMUTABLE STRICT

340 AS '$libdir/latlon-v0005', 'pgl_ecluster_overlap';

341

342 CREATE OR REPLACE FUNCTION ecluster_may_overlap_proc(ecluster, ecluster)

343 RETURNS boolean

344 LANGUAGE C IMMUTABLE STRICT

345 AS '$libdir/latlon-v0005', 'pgl_ecluster_may_overlap';

346

347 CREATE OR REPLACE FUNCTION ecluster_contains_proc(ecluster, ecluster)

348 RETURNS boolean

349 LANGUAGE C IMMUTABLE STRICT

350 AS '$libdir/latlon-v0005', 'pgl_ecluster_contains';

351

352 CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint)

353 RETURNS float8

354 LANGUAGE C IMMUTABLE STRICT

355 AS '$libdir/latlon-v0005', 'pgl_epoint_distance';

356

357 CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)

358 RETURNS float8

359 LANGUAGE C IMMUTABLE STRICT

360 AS '$libdir/latlon-v0005', 'pgl_epoint_ecircle_distance';

361

362 CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)

363 RETURNS float8

364 LANGUAGE C IMMUTABLE STRICT

365 AS '$libdir/latlon-v0005', 'pgl_epoint_ecluster_distance';

366

367 CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle)

368 RETURNS float8

369 LANGUAGE C IMMUTABLE STRICT

370 AS '$libdir/latlon-v0005', 'pgl_ecircle_distance';

371

372 CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)

373 RETURNS float8

374 LANGUAGE C IMMUTABLE STRICT

375 AS '$libdir/latlon-v0005', 'pgl_ecircle_ecluster_distance';

376

377 CREATE OR REPLACE FUNCTION ecluster_distance_proc(ecluster, ecluster)

378 RETURNS float8

379 LANGUAGE C IMMUTABLE STRICT

380 AS '$libdir/latlon-v0005', 'pgl_ecluster_distance';

381

382 CREATE FUNCTION ebox_contains_castwrap(ebox, ebox)

383 RETURNS boolean

384 LANGUAGE sql IMMUTABLE AS 'SELECT $1::ecluster @> $2::ecluster';

385

386 CREATE OPERATOR @> (

387 leftarg = ebox,

388 rightarg = ebox,

389 procedure = ebox_contains_castwrap,

390 commutator = <@,

391 restrict = areasel,

392 join = areajoinsel

393 );

394

395 CREATE FUNCTION ebox_contains_swapped_castwrap(ebox, ebox)

396 RETURNS boolean

397 LANGUAGE sql IMMUTABLE AS 'SELECT $2::ecluster @> $1::ecluster';

398

399 CREATE OPERATOR <@ (

400 leftarg = ebox,

401 rightarg = ebox,

402 procedure = ebox_contains_swapped_castwrap,

403 commutator = @>,

404 restrict = areasel,

405 join = areajoinsel

406 );

407

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

409 RETURNS boolean

410 LANGUAGE C STRICT

411 AS '$libdir/latlon-v0005', 'pgl_gist_consistent';

412

413 CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal)

414 RETURNS internal

415 LANGUAGE C STRICT

416 AS '$libdir/latlon-v0005', 'pgl_gist_union';

417

418 CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal)

419 RETURNS internal

420 LANGUAGE C STRICT

421 AS '$libdir/latlon-v0005', 'pgl_gist_compress_epoint';

422

423 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal)

424 RETURNS internal

425 LANGUAGE C STRICT

426 AS '$libdir/latlon-v0005', 'pgl_gist_compress_ecircle';

427

428 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal)

429 RETURNS internal

430 LANGUAGE C STRICT

431 AS '$libdir/latlon-v0005', 'pgl_gist_compress_ecluster';

432

433 CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal)

434 RETURNS internal

435 LANGUAGE C STRICT

436 AS '$libdir/latlon-v0005', 'pgl_gist_decompress';

437

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

439 RETURNS internal

440 LANGUAGE C STRICT

441 AS '$libdir/latlon-v0005', 'pgl_gist_penalty';

442

443 CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal)

444 RETURNS internal

445 LANGUAGE C STRICT

446 AS '$libdir/latlon-v0005', 'pgl_gist_picksplit';

447

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

449 RETURNS internal

450 LANGUAGE C STRICT

451 AS '$libdir/latlon-v0005', 'pgl_gist_same';

452

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

454 RETURNS internal

455 LANGUAGE C STRICT

456 AS '$libdir/latlon-v0005', 'pgl_gist_distance';

457