pgLatLon

annotate latlon--0.14--0.15.sql @ 69:882b77aee653

find changesets by author, revision, files, or words in the commit message
Prepared file names for version 0.15
author jbe
date Wed Feb 12 11:08:37 2020 +0100 (2020-02-12)
parents latlon--0.14.sql@da23ebd9fd4c
children b5bc6b35b716
rev   line source
jbe@0 1
jbe@0 2 ------------------------------------------------------------
jbe@0 3 -- dummy input/output functions for dummy index key types --
jbe@0 4 ------------------------------------------------------------
jbe@0 5
jbe@69 6 CREATE OR REPLACE FUNCTION ekey_point_in_dummy(cstring)
jbe@0 7 RETURNS ekey_point
jbe@0 8 LANGUAGE C IMMUTABLE STRICT
jbe@69 9 AS '$libdir/latlon-v0010', 'pgl_notimpl';
jbe@0 10
jbe@69 11 CREATE OR REPLACE FUNCTION ekey_point_out_dummy(ekey_point)
jbe@0 12 RETURNS cstring
jbe@0 13 LANGUAGE C IMMUTABLE STRICT
jbe@69 14 AS '$libdir/latlon-v0010', 'pgl_notimpl';
jbe@0 15
jbe@69 16 CREATE OR REPLACE FUNCTION ekey_area_in_dummy(cstring)
jbe@0 17 RETURNS ekey_area
jbe@0 18 LANGUAGE C IMMUTABLE STRICT
jbe@69 19 AS '$libdir/latlon-v0010', 'pgl_notimpl';
jbe@0 20
jbe@69 21 CREATE OR REPLACE FUNCTION ekey_area_out_dummy(ekey_area)
jbe@0 22 RETURNS cstring
jbe@0 23 LANGUAGE C IMMUTABLE STRICT
jbe@69 24 AS '$libdir/latlon-v0010', 'pgl_notimpl';
jbe@0 25
jbe@0 26
jbe@0 27 --------------------------
jbe@0 28 -- text input functions --
jbe@0 29 --------------------------
jbe@0 30
jbe@69 31 CREATE OR REPLACE FUNCTION epoint_in(cstring)
jbe@0 32 RETURNS epoint
jbe@0 33 LANGUAGE C IMMUTABLE STRICT
jbe@69 34 AS '$libdir/latlon-v0010', 'pgl_epoint_in';
jbe@46 35
jbe@69 36 CREATE OR REPLACE FUNCTION epoint_with_sample_count_in(cstring)
jbe@46 37 RETURNS epoint_with_sample_count
jbe@46 38 LANGUAGE C IMMUTABLE STRICT
jbe@69 39 AS '$libdir/latlon-v0010', 'pgl_epoint_with_sample_count_in';
jbe@0 40
jbe@69 41 CREATE OR REPLACE FUNCTION ebox_in(cstring)
jbe@0 42 RETURNS ebox
jbe@0 43 LANGUAGE C IMMUTABLE STRICT
jbe@69 44 AS '$libdir/latlon-v0010', 'pgl_ebox_in';
jbe@0 45
jbe@69 46 CREATE OR REPLACE FUNCTION ecircle_in(cstring)
jbe@0 47 RETURNS ecircle
jbe@0 48 LANGUAGE C IMMUTABLE STRICT
jbe@69 49 AS '$libdir/latlon-v0010', 'pgl_ecircle_in';
jbe@0 50
jbe@69 51 CREATE OR REPLACE FUNCTION ecluster_in(cstring)
jbe@0 52 RETURNS ecluster
jbe@0 53 LANGUAGE C IMMUTABLE STRICT
jbe@69 54 AS '$libdir/latlon-v0010', 'pgl_ecluster_in';
jbe@0 55
jbe@0 56
jbe@0 57 ---------------------------
jbe@0 58 -- text output functions --
jbe@0 59 ---------------------------
jbe@0 60
jbe@69 61 CREATE OR REPLACE FUNCTION epoint_out(epoint)
jbe@0 62 RETURNS cstring
jbe@0 63 LANGUAGE C IMMUTABLE STRICT
jbe@69 64 AS '$libdir/latlon-v0010', 'pgl_epoint_out';
jbe@46 65
jbe@69 66 CREATE OR REPLACE FUNCTION epoint_with_sample_count_out(epoint_with_sample_count)
jbe@46 67 RETURNS cstring
jbe@46 68 LANGUAGE C IMMUTABLE STRICT
jbe@69 69 AS '$libdir/latlon-v0010', 'pgl_epoint_with_sample_count_out';
jbe@0 70
jbe@69 71 CREATE OR REPLACE FUNCTION ebox_out(ebox)
jbe@0 72 RETURNS cstring
jbe@0 73 LANGUAGE C IMMUTABLE STRICT
jbe@69 74 AS '$libdir/latlon-v0010', 'pgl_ebox_out';
jbe@0 75
jbe@69 76 CREATE OR REPLACE FUNCTION ecircle_out(ecircle)
jbe@0 77 RETURNS cstring
jbe@0 78 LANGUAGE C IMMUTABLE STRICT
jbe@69 79 AS '$libdir/latlon-v0010', 'pgl_ecircle_out';
jbe@0 80
jbe@69 81 CREATE OR REPLACE FUNCTION ecluster_out(ecluster)
jbe@0 82 RETURNS cstring
jbe@0 83 LANGUAGE C IMMUTABLE STRICT
jbe@69 84 AS '$libdir/latlon-v0010', 'pgl_ecluster_out';
jbe@0 85
jbe@0 86
jbe@0 87 --------------------------
jbe@0 88 -- binary I/O functions --
jbe@0 89 --------------------------
jbe@0 90
jbe@69 91 CREATE OR REPLACE FUNCTION epoint_recv(internal)
jbe@0 92 RETURNS epoint
jbe@0 93 LANGUAGE C IMMUTABLE STRICT
jbe@69 94 AS '$libdir/latlon-v0010', 'pgl_epoint_recv';
jbe@0 95
jbe@69 96 CREATE OR REPLACE FUNCTION ebox_recv(internal)
jbe@0 97 RETURNS ebox
jbe@0 98 LANGUAGE C IMMUTABLE STRICT
jbe@69 99 AS '$libdir/latlon-v0010', 'pgl_ebox_recv';
jbe@0 100
jbe@69 101 CREATE OR REPLACE FUNCTION ecircle_recv(internal)
jbe@0 102 RETURNS ecircle
jbe@0 103 LANGUAGE C IMMUTABLE STRICT
jbe@69 104 AS '$libdir/latlon-v0010', 'pgl_ecircle_recv';
jbe@0 105
jbe@69 106 CREATE OR REPLACE FUNCTION epoint_send(epoint)
jbe@0 107 RETURNS bytea
jbe@0 108 LANGUAGE C IMMUTABLE STRICT
jbe@69 109 AS '$libdir/latlon-v0010', 'pgl_epoint_send';
jbe@0 110
jbe@69 111 CREATE OR REPLACE FUNCTION ebox_send(ebox)
jbe@69 112 RETURNS bytea
jbe@69 113 LANGUAGE C IMMUTABLE STRICT
jbe@69 114 AS '$libdir/latlon-v0010', 'pgl_ebox_send';
jbe@46 115
jbe@69 116 CREATE OR REPLACE FUNCTION ecircle_send(ecircle)
jbe@69 117 RETURNS bytea
jbe@69 118 LANGUAGE C IMMUTABLE STRICT
jbe@69 119 AS '$libdir/latlon-v0010', 'pgl_ecircle_send';
jbe@0 120
jbe@0 121
jbe@0 122 --------------------
jbe@0 123 -- B-tree support --
jbe@0 124 --------------------
jbe@0 125
jbe@0 126 -- begin of B-tree support for epoint
jbe@0 127
jbe@69 128 CREATE OR REPLACE FUNCTION epoint_btree_lt(epoint, epoint)
jbe@0 129 RETURNS boolean
jbe@0 130 LANGUAGE C IMMUTABLE STRICT
jbe@69 131 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_lt';
jbe@0 132
jbe@69 133 CREATE OR REPLACE FUNCTION epoint_btree_le(epoint, epoint)
jbe@0 134 RETURNS boolean
jbe@0 135 LANGUAGE C IMMUTABLE STRICT
jbe@69 136 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_le';
jbe@0 137
jbe@69 138 CREATE OR REPLACE FUNCTION epoint_btree_eq(epoint, epoint)
jbe@0 139 RETURNS boolean
jbe@0 140 LANGUAGE C IMMUTABLE STRICT
jbe@69 141 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_eq';
jbe@0 142
jbe@69 143 CREATE OR REPLACE FUNCTION epoint_btree_ne(epoint, epoint)
jbe@69 144 RETURNS boolean
jbe@69 145 LANGUAGE C IMMUTABLE STRICT
jbe@69 146 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_ne';
jbe@0 147
jbe@69 148 CREATE OR REPLACE FUNCTION epoint_btree_ge(epoint, epoint)
jbe@69 149 RETURNS boolean
jbe@69 150 LANGUAGE C IMMUTABLE STRICT
jbe@69 151 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_ge';
jbe@0 152
jbe@69 153 CREATE OR REPLACE FUNCTION epoint_btree_gt(epoint, epoint)
jbe@69 154 RETURNS boolean
jbe@69 155 LANGUAGE C IMMUTABLE STRICT
jbe@69 156 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_gt';
jbe@0 157
jbe@69 158 CREATE OR REPLACE FUNCTION epoint_btree_cmp(epoint, epoint)
jbe@0 159 RETURNS int4
jbe@0 160 LANGUAGE C IMMUTABLE STRICT
jbe@69 161 AS '$libdir/latlon-v0010', 'pgl_btree_epoint_cmp';
jbe@0 162
jbe@0 163 -- end of B-tree support for epoint
jbe@0 164
jbe@0 165 -- begin of B-tree support for ebox
jbe@0 166
jbe@69 167 CREATE OR REPLACE FUNCTION ebox_btree_lt(ebox, ebox)
jbe@0 168 RETURNS boolean
jbe@0 169 LANGUAGE C IMMUTABLE STRICT
jbe@69 170 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_lt';
jbe@0 171
jbe@69 172 CREATE OR REPLACE FUNCTION ebox_btree_le(ebox, ebox)
jbe@0 173 RETURNS boolean
jbe@0 174 LANGUAGE C IMMUTABLE STRICT
jbe@69 175 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_le';
jbe@0 176
jbe@69 177 CREATE OR REPLACE FUNCTION ebox_btree_eq(ebox, ebox)
jbe@0 178 RETURNS boolean
jbe@0 179 LANGUAGE C IMMUTABLE STRICT
jbe@69 180 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_eq';
jbe@0 181
jbe@69 182 CREATE OR REPLACE FUNCTION ebox_btree_ne(ebox, ebox)
jbe@69 183 RETURNS boolean
jbe@69 184 LANGUAGE C IMMUTABLE STRICT
jbe@69 185 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_ne';
jbe@0 186
jbe@69 187 CREATE OR REPLACE FUNCTION ebox_btree_ge(ebox, ebox)
jbe@69 188 RETURNS boolean
jbe@69 189 LANGUAGE C IMMUTABLE STRICT
jbe@69 190 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_ge';
jbe@0 191
jbe@69 192 CREATE OR REPLACE FUNCTION ebox_btree_gt(ebox, ebox)
jbe@69 193 RETURNS boolean
jbe@69 194 LANGUAGE C IMMUTABLE STRICT
jbe@69 195 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_gt';
jbe@0 196
jbe@69 197 CREATE OR REPLACE FUNCTION ebox_btree_cmp(ebox, ebox)
jbe@0 198 RETURNS int4
jbe@0 199 LANGUAGE C IMMUTABLE STRICT
jbe@69 200 AS '$libdir/latlon-v0010', 'pgl_btree_ebox_cmp';
jbe@0 201
jbe@0 202 -- end of B-tree support for ebox
jbe@0 203
jbe@0 204 -- begin of B-tree support for ecircle
jbe@0 205
jbe@69 206 CREATE OR REPLACE FUNCTION ecircle_btree_lt(ecircle, ecircle)
jbe@0 207 RETURNS boolean
jbe@0 208 LANGUAGE C IMMUTABLE STRICT
jbe@69 209 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_lt';
jbe@0 210
jbe@69 211 CREATE OR REPLACE FUNCTION ecircle_btree_le(ecircle, ecircle)
jbe@0 212 RETURNS boolean
jbe@0 213 LANGUAGE C IMMUTABLE STRICT
jbe@69 214 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_le';
jbe@0 215
jbe@69 216 CREATE OR REPLACE FUNCTION ecircle_btree_eq(ecircle, ecircle)
jbe@0 217 RETURNS boolean
jbe@0 218 LANGUAGE C IMMUTABLE STRICT
jbe@69 219 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_eq';
jbe@0 220
jbe@69 221 CREATE OR REPLACE FUNCTION ecircle_btree_ne(ecircle, ecircle)
jbe@69 222 RETURNS boolean
jbe@69 223 LANGUAGE C IMMUTABLE STRICT
jbe@69 224 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_ne';
jbe@0 225
jbe@69 226 CREATE OR REPLACE FUNCTION ecircle_btree_ge(ecircle, ecircle)
jbe@69 227 RETURNS boolean
jbe@69 228 LANGUAGE C IMMUTABLE STRICT
jbe@69 229 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_ge';
jbe@0 230
jbe@69 231 CREATE OR REPLACE FUNCTION ecircle_btree_gt(ecircle, ecircle)
jbe@69 232 RETURNS boolean
jbe@69 233 LANGUAGE C IMMUTABLE STRICT
jbe@69 234 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_gt';
jbe@0 235
jbe@69 236 CREATE OR REPLACE FUNCTION ecircle_btree_cmp(ecircle, ecircle)
jbe@0 237 RETURNS int4
jbe@0 238 LANGUAGE C IMMUTABLE STRICT
jbe@69 239 AS '$libdir/latlon-v0010', 'pgl_btree_ecircle_cmp';
jbe@0 240
jbe@0 241 -- end of B-tree support for ecircle
jbe@0 242
jbe@0 243
jbe@0 244 ----------------
jbe@0 245 -- type casts --
jbe@0 246 ----------------
jbe@0 247
jbe@69 248 CREATE OR REPLACE FUNCTION cast_epoint_to_ebox(epoint)
jbe@0 249 RETURNS ebox
jbe@0 250 LANGUAGE C IMMUTABLE STRICT
jbe@69 251 AS '$libdir/latlon-v0010', 'pgl_epoint_to_ebox';
jbe@0 252
jbe@69 253 CREATE OR REPLACE FUNCTION cast_epoint_to_ecircle(epoint)
jbe@0 254 RETURNS ecircle
jbe@0 255 LANGUAGE C IMMUTABLE STRICT
jbe@69 256 AS '$libdir/latlon-v0010', 'pgl_epoint_to_ecircle';
jbe@0 257
jbe@69 258 CREATE OR REPLACE FUNCTION cast_epoint_to_ecluster(epoint)
jbe@0 259 RETURNS ecluster
jbe@0 260 LANGUAGE C IMMUTABLE STRICT
jbe@69 261 AS '$libdir/latlon-v0010', 'pgl_epoint_to_ecluster';
jbe@0 262
jbe@69 263 CREATE OR REPLACE FUNCTION cast_ebox_to_ecluster(ebox)
jbe@0 264 RETURNS ecluster
jbe@0 265 LANGUAGE C IMMUTABLE STRICT
jbe@69 266 AS '$libdir/latlon-v0010', 'pgl_ebox_to_ecluster';
jbe@0 267
jbe@0 268
jbe@0 269 ---------------------------
jbe@0 270 -- constructor functions --
jbe@0 271 ---------------------------
jbe@0 272
jbe@69 273 CREATE OR REPLACE FUNCTION epoint(float8, float8)
jbe@0 274 RETURNS epoint
jbe@0 275 LANGUAGE C IMMUTABLE STRICT
jbe@69 276 AS '$libdir/latlon-v0010', 'pgl_create_epoint';
jbe@0 277
jbe@69 278 CREATE OR REPLACE FUNCTION epoint_with_sample_count(epoint, int4)
jbe@46 279 RETURNS epoint_with_sample_count
jbe@46 280 LANGUAGE C IMMUTABLE STRICT
jbe@69 281 AS '$libdir/latlon-v0010', 'pgl_create_epoint_with_sample_count';
jbe@46 282
jbe@69 283 CREATE OR REPLACE FUNCTION empty_ebox()
jbe@0 284 RETURNS ebox
jbe@0 285 LANGUAGE C IMMUTABLE STRICT
jbe@69 286 AS '$libdir/latlon-v0010', 'pgl_create_empty_ebox';
jbe@0 287
jbe@69 288 CREATE OR REPLACE FUNCTION ebox(float8, float8, float8, float8)
jbe@0 289 RETURNS ebox
jbe@0 290 LANGUAGE C IMMUTABLE STRICT
jbe@69 291 AS '$libdir/latlon-v0010', 'pgl_create_ebox';
jbe@0 292
jbe@69 293 CREATE OR REPLACE FUNCTION ebox(epoint, epoint)
jbe@69 294 RETURNS ebox
jbe@0 295 LANGUAGE C IMMUTABLE STRICT
jbe@69 296 AS '$libdir/latlon-v0010', 'pgl_create_ebox_from_epoints';
jbe@0 297
jbe@69 298 CREATE OR REPLACE FUNCTION ecircle(float8, float8, float8)
jbe@0 299 RETURNS ecircle
jbe@0 300 LANGUAGE C IMMUTABLE STRICT
jbe@69 301 AS '$libdir/latlon-v0010', 'pgl_create_ecircle';
jbe@0 302
jbe@69 303 CREATE OR REPLACE FUNCTION ecircle(epoint, float8)
jbe@69 304 RETURNS ecircle
jbe@69 305 LANGUAGE C IMMUTABLE STRICT
jbe@69 306 AS '$libdir/latlon-v0010', 'pgl_create_ecircle_from_epoint';
jbe@0 307
jbe@0 308
jbe@0 309 ----------------------
jbe@0 310 -- getter functions --
jbe@0 311 ----------------------
jbe@0 312
jbe@69 313 CREATE OR REPLACE FUNCTION latitude(epoint)
jbe@0 314 RETURNS float8
jbe@0 315 LANGUAGE C IMMUTABLE STRICT
jbe@69 316 AS '$libdir/latlon-v0010', 'pgl_epoint_lat';
jbe@0 317
jbe@69 318 CREATE OR REPLACE FUNCTION longitude(epoint)
jbe@0 319 RETURNS float8
jbe@0 320 LANGUAGE C IMMUTABLE STRICT
jbe@69 321 AS '$libdir/latlon-v0010', 'pgl_epoint_lon';
jbe@0 322
jbe@69 323 CREATE OR REPLACE FUNCTION min_latitude(ebox)
jbe@0 324 RETURNS float8
jbe@0 325 LANGUAGE C IMMUTABLE STRICT
jbe@69 326 AS '$libdir/latlon-v0010', 'pgl_ebox_lat_min';
jbe@0 327
jbe@69 328 CREATE OR REPLACE FUNCTION max_latitude(ebox)
jbe@0 329 RETURNS float8
jbe@0 330 LANGUAGE C IMMUTABLE STRICT
jbe@69 331 AS '$libdir/latlon-v0010', 'pgl_ebox_lat_max';
jbe@0 332
jbe@69 333 CREATE OR REPLACE FUNCTION min_longitude(ebox)
jbe@69 334 RETURNS float8
jbe@69 335 LANGUAGE C IMMUTABLE STRICT
jbe@69 336 AS '$libdir/latlon-v0010', 'pgl_ebox_lon_min';
jbe@0 337
jbe@69 338 CREATE OR REPLACE FUNCTION max_longitude(ebox)
jbe@69 339 RETURNS float8
jbe@69 340 LANGUAGE C IMMUTABLE STRICT
jbe@69 341 AS '$libdir/latlon-v0010', 'pgl_ebox_lon_max';
jbe@0 342
jbe@69 343 CREATE OR REPLACE FUNCTION center(ecircle)
jbe@69 344 RETURNS epoint
jbe@69 345 LANGUAGE C IMMUTABLE STRICT
jbe@69 346 AS '$libdir/latlon-v0010', 'pgl_ecircle_center';
jbe@69 347
jbe@69 348 CREATE OR REPLACE FUNCTION radius(ecircle)
jbe@69 349 RETURNS float8
jbe@69 350 LANGUAGE C IMMUTABLE STRICT
jbe@69 351 AS '$libdir/latlon-v0010', 'pgl_ecircle_radius';
jbe@0 352
jbe@0 353
jbe@0 354 ---------------
jbe@0 355 -- operators --
jbe@0 356 ---------------
jbe@0 357
jbe@69 358 CREATE OR REPLACE FUNCTION epoint_ebox_overlap_proc(epoint, ebox)
jbe@0 359 RETURNS boolean
jbe@0 360 LANGUAGE C IMMUTABLE STRICT
jbe@69 361 AS '$libdir/latlon-v0010', 'pgl_epoint_ebox_overlap';
jbe@0 362
jbe@69 363 CREATE OR REPLACE FUNCTION epoint_ecircle_overlap_proc(epoint, ecircle)
jbe@0 364 RETURNS boolean
jbe@0 365 LANGUAGE C IMMUTABLE STRICT
jbe@69 366 AS '$libdir/latlon-v0010', 'pgl_epoint_ecircle_overlap';
jbe@0 367
jbe@69 368 CREATE OR REPLACE FUNCTION epoint_ecluster_overlap_proc(epoint, ecluster)
jbe@0 369 RETURNS boolean
jbe@0 370 LANGUAGE C IMMUTABLE STRICT
jbe@69 371 AS '$libdir/latlon-v0010', 'pgl_epoint_ecluster_overlap';
jbe@0 372
jbe@69 373 CREATE OR REPLACE FUNCTION epoint_ecluster_may_overlap_proc(epoint, ecluster)
jbe@10 374 RETURNS boolean
jbe@10 375 LANGUAGE C IMMUTABLE STRICT
jbe@69 376 AS '$libdir/latlon-v0010', 'pgl_epoint_ecluster_may_overlap';
jbe@10 377
jbe@69 378 CREATE OR REPLACE FUNCTION ebox_overlap_proc(ebox, ebox)
jbe@0 379 RETURNS boolean
jbe@0 380 LANGUAGE C IMMUTABLE STRICT
jbe@69 381 AS '$libdir/latlon-v0010', 'pgl_ebox_overlap';
jbe@0 382
jbe@69 383 CREATE OR REPLACE FUNCTION ebox_ecircle_may_overlap_proc(ebox, ecircle)
jbe@0 384 RETURNS boolean
jbe@0 385 LANGUAGE C IMMUTABLE STRICT
jbe@69 386 AS '$libdir/latlon-v0010', 'pgl_ebox_ecircle_may_overlap';
jbe@0 387
jbe@69 388 CREATE OR REPLACE FUNCTION ebox_ecluster_may_overlap_proc(ebox, ecluster)
jbe@10 389 RETURNS boolean
jbe@10 390 LANGUAGE C IMMUTABLE STRICT
jbe@69 391 AS '$libdir/latlon-v0010', 'pgl_ebox_ecluster_may_overlap';
jbe@10 392
jbe@69 393 CREATE OR REPLACE FUNCTION ecircle_overlap_proc(ecircle, ecircle)
jbe@16 394 RETURNS boolean
jbe@16 395 LANGUAGE C IMMUTABLE STRICT
jbe@69 396 AS '$libdir/latlon-v0010', 'pgl_ecircle_overlap';
jbe@16 397
jbe@69 398 CREATE OR REPLACE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster)
jbe@10 399 RETURNS boolean
jbe@10 400 LANGUAGE C IMMUTABLE STRICT
jbe@69 401 AS '$libdir/latlon-v0010', 'pgl_ecircle_ecluster_overlap';
jbe@10 402
jbe@69 403 CREATE OR REPLACE FUNCTION ecircle_ecluster_may_overlap_proc(ecircle, ecluster)
jbe@16 404 RETURNS boolean
jbe@16 405 LANGUAGE C IMMUTABLE STRICT
jbe@69 406 AS '$libdir/latlon-v0010', 'pgl_ecircle_ecluster_may_overlap';
jbe@0 407
jbe@69 408 CREATE OR REPLACE FUNCTION ecluster_overlap_proc(ecluster, ecluster)
jbe@69 409 RETURNS boolean
jbe@0 410 LANGUAGE C IMMUTABLE STRICT
jbe@69 411 AS '$libdir/latlon-v0010', 'pgl_ecluster_overlap';
jbe@0 412
jbe@69 413 CREATE OR REPLACE FUNCTION ecluster_may_overlap_proc(ecluster, ecluster)
jbe@69 414 RETURNS boolean
jbe@0 415 LANGUAGE C IMMUTABLE STRICT
jbe@69 416 AS '$libdir/latlon-v0010', 'pgl_ecluster_may_overlap';
jbe@0 417
jbe@69 418 CREATE OR REPLACE FUNCTION ecluster_contains_proc(ecluster, ecluster)
jbe@69 419 RETURNS boolean
jbe@16 420 LANGUAGE C IMMUTABLE STRICT
jbe@69 421 AS '$libdir/latlon-v0010', 'pgl_ecluster_contains';
jbe@46 422
jbe@69 423 CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint)
jbe@46 424 RETURNS float8
jbe@46 425 LANGUAGE C IMMUTABLE STRICT
jbe@69 426 AS '$libdir/latlon-v0010', 'pgl_epoint_distance';
jbe@16 427
jbe@69 428 CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)
jbe@69 429 RETURNS float8
jbe@69 430 LANGUAGE C IMMUTABLE STRICT
jbe@69 431 AS '$libdir/latlon-v0010', 'pgl_epoint_ecircle_distance';
jbe@10 432
jbe@69 433 CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)
jbe@69 434 RETURNS float8
jbe@69 435 LANGUAGE C IMMUTABLE STRICT
jbe@69 436 AS '$libdir/latlon-v0010', 'pgl_epoint_ecluster_distance';
jbe@16 437
jbe@69 438 CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle)
jbe@69 439 RETURNS float8
jbe@69 440 LANGUAGE C IMMUTABLE STRICT
jbe@69 441 AS '$libdir/latlon-v0010', 'pgl_ecircle_distance';
jbe@20 442
jbe@69 443 CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)
jbe@69 444 RETURNS float8
jbe@69 445 LANGUAGE C IMMUTABLE STRICT
jbe@69 446 AS '$libdir/latlon-v0010', 'pgl_ecircle_ecluster_distance';
jbe@0 447
jbe@69 448 CREATE OR REPLACE FUNCTION ecluster_distance_proc(ecluster, ecluster)
jbe@0 449 RETURNS float8
jbe@69 450 LANGUAGE C IMMUTABLE STRICT
jbe@69 451 AS '$libdir/latlon-v0010', 'pgl_ecluster_distance';
jbe@16 452
jbe@69 453 CREATE OR REPLACE FUNCTION fair_distance_operator_proc(ecluster, epoint_with_sample_count)
jbe@16 454 RETURNS float8
jbe@69 455 LANGUAGE C IMMUTABLE STRICT
jbe@69 456 AS '$libdir/latlon-v0010', 'pgl_ecluster_epoint_sc_fair_distance';
jbe@42 457
jbe@42 458
jbe@0 459 ----------------
jbe@0 460 -- GiST index --
jbe@0 461 ----------------
jbe@0 462
jbe@69 463 CREATE OR REPLACE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal)
jbe@0 464 RETURNS boolean
jbe@0 465 LANGUAGE C STRICT
jbe@69 466 AS '$libdir/latlon-v0010', 'pgl_gist_consistent';
jbe@0 467
jbe@69 468 CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal)
jbe@0 469 RETURNS internal
jbe@0 470 LANGUAGE C STRICT
jbe@69 471 AS '$libdir/latlon-v0010', 'pgl_gist_union';
jbe@0 472
jbe@69 473 CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal)
jbe@0 474 RETURNS internal
jbe@0 475 LANGUAGE C STRICT
jbe@69 476 AS '$libdir/latlon-v0010', 'pgl_gist_compress_epoint';
jbe@0 477
jbe@69 478 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal)
jbe@0 479 RETURNS internal
jbe@0 480 LANGUAGE C STRICT
jbe@69 481 AS '$libdir/latlon-v0010', 'pgl_gist_compress_ecircle';
jbe@0 482
jbe@69 483 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal)
jbe@0 484 RETURNS internal
jbe@0 485 LANGUAGE C STRICT
jbe@69 486 AS '$libdir/latlon-v0010', 'pgl_gist_compress_ecluster';
jbe@0 487
jbe@69 488 CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal)
jbe@69 489 RETURNS internal
jbe@69 490 LANGUAGE C STRICT
jbe@69 491 AS '$libdir/latlon-v0010', 'pgl_gist_decompress';
jbe@0 492
jbe@69 493 CREATE OR REPLACE FUNCTION pgl_gist_penalty(internal, internal, internal)
jbe@69 494 RETURNS internal
jbe@69 495 LANGUAGE C STRICT
jbe@69 496 AS '$libdir/latlon-v0010', 'pgl_gist_penalty';
jbe@0 497
jbe@69 498 CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal)
jbe@69 499 RETURNS internal
jbe@69 500 LANGUAGE C STRICT
jbe@69 501 AS '$libdir/latlon-v0010', 'pgl_gist_picksplit';
jbe@0 502
jbe@69 503 CREATE OR REPLACE FUNCTION pgl_gist_same(internal, internal, internal)
jbe@69 504 RETURNS internal
jbe@69 505 LANGUAGE C STRICT
jbe@69 506 AS '$libdir/latlon-v0010', 'pgl_gist_same';
jbe@0 507
jbe@69 508 CREATE OR REPLACE FUNCTION pgl_gist_distance(internal, internal, smallint, oid)
jbe@69 509 RETURNS internal
jbe@69 510 LANGUAGE C STRICT
jbe@69 511 AS '$libdir/latlon-v0010', 'pgl_gist_distance';
jbe@69 512

Impressum / About Us