1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/latlon--0.4.sql	Sat Sep 03 16:00:22 2016 +0200
     1.3 @@ -0,0 +1,1335 @@
     1.4 +
     1.5 +----------------------------------------
     1.6 +-- forward declarations (shell types) --
     1.7 +----------------------------------------
     1.8 +
     1.9 +CREATE TYPE epoint;
    1.10 +CREATE TYPE ebox;
    1.11 +CREATE TYPE ecircle;
    1.12 +CREATE TYPE ecluster;
    1.13 +
    1.14 +
    1.15 +------------------------------------------------------------
    1.16 +-- dummy input/output functions for dummy index key types --
    1.17 +------------------------------------------------------------
    1.18 +
    1.19 +CREATE FUNCTION ekey_point_in_dummy(cstring)
    1.20 +  RETURNS ekey_point
    1.21 +  LANGUAGE C IMMUTABLE STRICT
    1.22 +  AS '$libdir/latlon-v0004', 'pgl_notimpl';
    1.23 +
    1.24 +CREATE FUNCTION ekey_point_out_dummy(ekey_point)
    1.25 +  RETURNS cstring
    1.26 +  LANGUAGE C IMMUTABLE STRICT
    1.27 +  AS '$libdir/latlon-v0004', 'pgl_notimpl';
    1.28 +
    1.29 +CREATE FUNCTION ekey_area_in_dummy(cstring)
    1.30 +  RETURNS ekey_area
    1.31 +  LANGUAGE C IMMUTABLE STRICT
    1.32 +  AS '$libdir/latlon-v0004', 'pgl_notimpl';
    1.33 +
    1.34 +CREATE FUNCTION ekey_area_out_dummy(ekey_area)
    1.35 +  RETURNS cstring
    1.36 +  LANGUAGE C IMMUTABLE STRICT
    1.37 +  AS '$libdir/latlon-v0004', 'pgl_notimpl';
    1.38 +
    1.39 +
    1.40 +--------------------------
    1.41 +-- text input functions --
    1.42 +--------------------------
    1.43 +
    1.44 +CREATE FUNCTION epoint_in(cstring)
    1.45 +  RETURNS epoint
    1.46 +  LANGUAGE C IMMUTABLE STRICT
    1.47 +  AS '$libdir/latlon-v0004', 'pgl_epoint_in';
    1.48 +
    1.49 +CREATE FUNCTION ebox_in(cstring)
    1.50 +  RETURNS ebox
    1.51 +  LANGUAGE C IMMUTABLE STRICT
    1.52 +  AS '$libdir/latlon-v0004', 'pgl_ebox_in';
    1.53 +
    1.54 +CREATE FUNCTION ecircle_in(cstring)
    1.55 +  RETURNS ecircle
    1.56 +  LANGUAGE C IMMUTABLE STRICT
    1.57 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_in';
    1.58 +
    1.59 +CREATE FUNCTION ecluster_in(cstring)
    1.60 +  RETURNS ecluster
    1.61 +  LANGUAGE C IMMUTABLE STRICT
    1.62 +  AS '$libdir/latlon-v0004', 'pgl_ecluster_in';
    1.63 +
    1.64 +
    1.65 +---------------------------
    1.66 +-- text output functions --
    1.67 +---------------------------
    1.68 +
    1.69 +CREATE FUNCTION epoint_out(epoint)
    1.70 +  RETURNS cstring
    1.71 +  LANGUAGE C IMMUTABLE STRICT
    1.72 +  AS '$libdir/latlon-v0004', 'pgl_epoint_out';
    1.73 +
    1.74 +CREATE FUNCTION ebox_out(ebox)
    1.75 +  RETURNS cstring
    1.76 +  LANGUAGE C IMMUTABLE STRICT
    1.77 +  AS '$libdir/latlon-v0004', 'pgl_ebox_out';
    1.78 +
    1.79 +CREATE FUNCTION ecircle_out(ecircle)
    1.80 +  RETURNS cstring
    1.81 +  LANGUAGE C IMMUTABLE STRICT
    1.82 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_out';
    1.83 +
    1.84 +CREATE FUNCTION ecluster_out(ecluster)
    1.85 +  RETURNS cstring
    1.86 +  LANGUAGE C IMMUTABLE STRICT
    1.87 +  AS '$libdir/latlon-v0004', 'pgl_ecluster_out';
    1.88 +
    1.89 +
    1.90 +--------------------------
    1.91 +-- binary I/O functions --
    1.92 +--------------------------
    1.93 +
    1.94 +CREATE FUNCTION epoint_recv(internal)
    1.95 +  RETURNS epoint
    1.96 +  LANGUAGE C IMMUTABLE STRICT
    1.97 +  AS '$libdir/latlon-v0004', 'pgl_epoint_recv';
    1.98 +
    1.99 +CREATE FUNCTION ebox_recv(internal)
   1.100 +  RETURNS ebox
   1.101 +  LANGUAGE C IMMUTABLE STRICT
   1.102 +  AS '$libdir/latlon-v0004', 'pgl_ebox_recv';
   1.103 +
   1.104 +CREATE FUNCTION ecircle_recv(internal)
   1.105 +  RETURNS ecircle
   1.106 +  LANGUAGE C IMMUTABLE STRICT
   1.107 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_recv';
   1.108 +
   1.109 +CREATE FUNCTION epoint_send(epoint)
   1.110 +  RETURNS bytea
   1.111 +  LANGUAGE C IMMUTABLE STRICT
   1.112 +  AS '$libdir/latlon-v0004', 'pgl_epoint_send';
   1.113 +
   1.114 +CREATE FUNCTION ebox_send(ebox)
   1.115 +  RETURNS bytea
   1.116 +  LANGUAGE C IMMUTABLE STRICT
   1.117 +  AS '$libdir/latlon-v0004', 'pgl_ebox_send';
   1.118 +
   1.119 +CREATE FUNCTION ecircle_send(ecircle)
   1.120 +  RETURNS bytea
   1.121 +  LANGUAGE C IMMUTABLE STRICT
   1.122 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_send';
   1.123 +
   1.124 +
   1.125 +-----------------------------------------------
   1.126 +-- type definitions of dummy index key types --
   1.127 +-----------------------------------------------
   1.128 +
   1.129 +CREATE TYPE ekey_point (
   1.130 +  internallength = 8,
   1.131 +  input = ekey_point_in_dummy,
   1.132 +  output = ekey_point_out_dummy,
   1.133 +  alignment = char );
   1.134 +
   1.135 +CREATE TYPE ekey_area (
   1.136 +  internallength = 9,
   1.137 +  input = ekey_area_in_dummy,
   1.138 +  output = ekey_area_out_dummy,
   1.139 +  alignment = char );
   1.140 +
   1.141 +
   1.142 +------------------------------------------
   1.143 +-- definitions of geographic data types --
   1.144 +------------------------------------------
   1.145 +
   1.146 +CREATE TYPE epoint (
   1.147 +  internallength = 16,
   1.148 +  input = epoint_in,
   1.149 +  output = epoint_out,
   1.150 +  receive = epoint_recv,
   1.151 +  send = epoint_send,
   1.152 +  alignment = double );
   1.153 +
   1.154 +CREATE TYPE ebox (
   1.155 +  internallength = 32,
   1.156 +  input = ebox_in,
   1.157 +  output = ebox_out,
   1.158 +  receive = ebox_recv,
   1.159 +  send = ebox_send,
   1.160 +  alignment = double );
   1.161 +
   1.162 +CREATE TYPE ecircle (
   1.163 +  internallength = 24,
   1.164 +  input = ecircle_in,
   1.165 +  output = ecircle_out,
   1.166 +  receive = ecircle_recv,
   1.167 +  send = ecircle_send,
   1.168 +  alignment = double );
   1.169 +
   1.170 +CREATE TYPE ecluster (
   1.171 +  internallength = VARIABLE,
   1.172 +  input = ecluster_in,
   1.173 +  output = ecluster_out,
   1.174 +  alignment = double,
   1.175 +  storage = external );
   1.176 +
   1.177 +
   1.178 +--------------------
   1.179 +-- B-tree support --
   1.180 +--------------------
   1.181 +
   1.182 +-- begin of B-tree support for epoint
   1.183 +
   1.184 +CREATE FUNCTION epoint_btree_lt(epoint, epoint)
   1.185 +  RETURNS boolean
   1.186 +  LANGUAGE C IMMUTABLE STRICT
   1.187 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_lt';
   1.188 +
   1.189 +CREATE FUNCTION epoint_btree_le(epoint, epoint)
   1.190 +  RETURNS boolean
   1.191 +  LANGUAGE C IMMUTABLE STRICT
   1.192 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_le';
   1.193 +
   1.194 +CREATE FUNCTION epoint_btree_eq(epoint, epoint)
   1.195 +  RETURNS boolean
   1.196 +  LANGUAGE C IMMUTABLE STRICT
   1.197 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_eq';
   1.198 +
   1.199 +CREATE FUNCTION epoint_btree_ne(epoint, epoint)
   1.200 +  RETURNS boolean
   1.201 +  LANGUAGE C IMMUTABLE STRICT
   1.202 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_ne';
   1.203 +
   1.204 +CREATE FUNCTION epoint_btree_ge(epoint, epoint)
   1.205 +  RETURNS boolean
   1.206 +  LANGUAGE C IMMUTABLE STRICT
   1.207 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_ge';
   1.208 +
   1.209 +CREATE FUNCTION epoint_btree_gt(epoint, epoint)
   1.210 +  RETURNS boolean
   1.211 +  LANGUAGE C IMMUTABLE STRICT
   1.212 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_gt';
   1.213 +
   1.214 +CREATE OPERATOR <<< (
   1.215 +  leftarg = epoint,
   1.216 +  rightarg = epoint,
   1.217 +  procedure = epoint_btree_lt,
   1.218 +  commutator = >>>,
   1.219 +  negator = >>>=,
   1.220 +  restrict = scalarltsel,
   1.221 +  join = scalarltjoinsel
   1.222 +);
   1.223 +
   1.224 +CREATE OPERATOR <<<= (
   1.225 +  leftarg = epoint,
   1.226 +  rightarg = epoint,
   1.227 +  procedure = epoint_btree_le,
   1.228 +  commutator = >>>=,
   1.229 +  negator = >>>,
   1.230 +  restrict = scalarltsel,
   1.231 +  join = scalarltjoinsel
   1.232 +);
   1.233 +
   1.234 +CREATE OPERATOR = (
   1.235 +  leftarg = epoint,
   1.236 +  rightarg = epoint,
   1.237 +  procedure = epoint_btree_eq,
   1.238 +  commutator = =,
   1.239 +  negator = <>,
   1.240 +  restrict = eqsel,
   1.241 +  join = eqjoinsel,
   1.242 +  merges
   1.243 +);
   1.244 +
   1.245 +CREATE OPERATOR <> (
   1.246 +  leftarg = epoint,
   1.247 +  rightarg = epoint,
   1.248 +  procedure = epoint_btree_eq,
   1.249 +  commutator = <>,
   1.250 +  negator = =,
   1.251 +  restrict = neqsel,
   1.252 +  join = neqjoinsel
   1.253 +);
   1.254 +
   1.255 +CREATE OPERATOR >>>= (
   1.256 +  leftarg = epoint,
   1.257 +  rightarg = epoint,
   1.258 +  procedure = epoint_btree_ge,
   1.259 +  commutator = <<<=,
   1.260 +  negator = <<<,
   1.261 +  restrict = scalargtsel,
   1.262 +  join = scalargtjoinsel
   1.263 +);
   1.264 +
   1.265 +CREATE OPERATOR >>> (
   1.266 +  leftarg = epoint,
   1.267 +  rightarg = epoint,
   1.268 +  procedure = epoint_btree_gt,
   1.269 +  commutator = <<<,
   1.270 +  negator = <<<=,
   1.271 +  restrict = scalargtsel,
   1.272 +  join = scalargtjoinsel
   1.273 +);
   1.274 +
   1.275 +CREATE FUNCTION epoint_btree_cmp(epoint, epoint)
   1.276 +  RETURNS int4
   1.277 +  LANGUAGE C IMMUTABLE STRICT
   1.278 +  AS '$libdir/latlon-v0004', 'pgl_btree_epoint_cmp';
   1.279 +
   1.280 +CREATE OPERATOR CLASS epoint_btree_ops
   1.281 +  DEFAULT FOR TYPE epoint USING btree AS
   1.282 +  OPERATOR 1 <<< ,
   1.283 +  OPERATOR 2 <<<= ,
   1.284 +  OPERATOR 3 = ,
   1.285 +  OPERATOR 4 >>>= ,
   1.286 +  OPERATOR 5 >>> ,
   1.287 +  FUNCTION 1 epoint_btree_cmp(epoint, epoint);
   1.288 +
   1.289 +-- end of B-tree support for epoint
   1.290 +
   1.291 +-- begin of B-tree support for ebox
   1.292 +
   1.293 +CREATE FUNCTION ebox_btree_lt(ebox, ebox)
   1.294 +  RETURNS boolean
   1.295 +  LANGUAGE C IMMUTABLE STRICT
   1.296 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_lt';
   1.297 +
   1.298 +CREATE FUNCTION ebox_btree_le(ebox, ebox)
   1.299 +  RETURNS boolean
   1.300 +  LANGUAGE C IMMUTABLE STRICT
   1.301 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_le';
   1.302 +
   1.303 +CREATE FUNCTION ebox_btree_eq(ebox, ebox)
   1.304 +  RETURNS boolean
   1.305 +  LANGUAGE C IMMUTABLE STRICT
   1.306 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_eq';
   1.307 +
   1.308 +CREATE FUNCTION ebox_btree_ne(ebox, ebox)
   1.309 +  RETURNS boolean
   1.310 +  LANGUAGE C IMMUTABLE STRICT
   1.311 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_ne';
   1.312 +
   1.313 +CREATE FUNCTION ebox_btree_ge(ebox, ebox)
   1.314 +  RETURNS boolean
   1.315 +  LANGUAGE C IMMUTABLE STRICT
   1.316 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_ge';
   1.317 +
   1.318 +CREATE FUNCTION ebox_btree_gt(ebox, ebox)
   1.319 +  RETURNS boolean
   1.320 +  LANGUAGE C IMMUTABLE STRICT
   1.321 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_gt';
   1.322 +
   1.323 +CREATE OPERATOR <<< (
   1.324 +  leftarg = ebox,
   1.325 +  rightarg = ebox,
   1.326 +  procedure = ebox_btree_lt,
   1.327 +  commutator = >>>,
   1.328 +  negator = >>>=,
   1.329 +  restrict = scalarltsel,
   1.330 +  join = scalarltjoinsel
   1.331 +);
   1.332 +
   1.333 +CREATE OPERATOR <<<= (
   1.334 +  leftarg = ebox,
   1.335 +  rightarg = ebox,
   1.336 +  procedure = ebox_btree_le,
   1.337 +  commutator = >>>=,
   1.338 +  negator = >>>,
   1.339 +  restrict = scalarltsel,
   1.340 +  join = scalarltjoinsel
   1.341 +);
   1.342 +
   1.343 +CREATE OPERATOR = (
   1.344 +  leftarg = ebox,
   1.345 +  rightarg = ebox,
   1.346 +  procedure = ebox_btree_eq,
   1.347 +  commutator = =,
   1.348 +  negator = <>,
   1.349 +  restrict = eqsel,
   1.350 +  join = eqjoinsel,
   1.351 +  merges
   1.352 +);
   1.353 +
   1.354 +CREATE OPERATOR <> (
   1.355 +  leftarg = ebox,
   1.356 +  rightarg = ebox,
   1.357 +  procedure = ebox_btree_eq,
   1.358 +  commutator = <>,
   1.359 +  negator = =,
   1.360 +  restrict = neqsel,
   1.361 +  join = neqjoinsel
   1.362 +);
   1.363 +
   1.364 +CREATE OPERATOR >>>= (
   1.365 +  leftarg = ebox,
   1.366 +  rightarg = ebox,
   1.367 +  procedure = ebox_btree_ge,
   1.368 +  commutator = <<<=,
   1.369 +  negator = <<<,
   1.370 +  restrict = scalargtsel,
   1.371 +  join = scalargtjoinsel
   1.372 +);
   1.373 +
   1.374 +CREATE OPERATOR >>> (
   1.375 +  leftarg = ebox,
   1.376 +  rightarg = ebox,
   1.377 +  procedure = ebox_btree_gt,
   1.378 +  commutator = <<<,
   1.379 +  negator = <<<=,
   1.380 +  restrict = scalargtsel,
   1.381 +  join = scalargtjoinsel
   1.382 +);
   1.383 +
   1.384 +CREATE FUNCTION ebox_btree_cmp(ebox, ebox)
   1.385 +  RETURNS int4
   1.386 +  LANGUAGE C IMMUTABLE STRICT
   1.387 +  AS '$libdir/latlon-v0004', 'pgl_btree_ebox_cmp';
   1.388 +
   1.389 +CREATE OPERATOR CLASS ebox_btree_ops
   1.390 +  DEFAULT FOR TYPE ebox USING btree AS
   1.391 +  OPERATOR 1 <<< ,
   1.392 +  OPERATOR 2 <<<= ,
   1.393 +  OPERATOR 3 = ,
   1.394 +  OPERATOR 4 >>>= ,
   1.395 +  OPERATOR 5 >>> ,
   1.396 +  FUNCTION 1 ebox_btree_cmp(ebox, ebox);
   1.397 +
   1.398 +-- end of B-tree support for ebox
   1.399 +
   1.400 +-- begin of B-tree support for ecircle
   1.401 +
   1.402 +CREATE FUNCTION ecircle_btree_lt(ecircle, ecircle)
   1.403 +  RETURNS boolean
   1.404 +  LANGUAGE C IMMUTABLE STRICT
   1.405 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_lt';
   1.406 +
   1.407 +CREATE FUNCTION ecircle_btree_le(ecircle, ecircle)
   1.408 +  RETURNS boolean
   1.409 +  LANGUAGE C IMMUTABLE STRICT
   1.410 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_le';
   1.411 +
   1.412 +CREATE FUNCTION ecircle_btree_eq(ecircle, ecircle)
   1.413 +  RETURNS boolean
   1.414 +  LANGUAGE C IMMUTABLE STRICT
   1.415 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_eq';
   1.416 +
   1.417 +CREATE FUNCTION ecircle_btree_ne(ecircle, ecircle)
   1.418 +  RETURNS boolean
   1.419 +  LANGUAGE C IMMUTABLE STRICT
   1.420 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_ne';
   1.421 +
   1.422 +CREATE FUNCTION ecircle_btree_ge(ecircle, ecircle)
   1.423 +  RETURNS boolean
   1.424 +  LANGUAGE C IMMUTABLE STRICT
   1.425 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_ge';
   1.426 +
   1.427 +CREATE FUNCTION ecircle_btree_gt(ecircle, ecircle)
   1.428 +  RETURNS boolean
   1.429 +  LANGUAGE C IMMUTABLE STRICT
   1.430 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_gt';
   1.431 +
   1.432 +CREATE OPERATOR <<< (
   1.433 +  leftarg = ecircle,
   1.434 +  rightarg = ecircle,
   1.435 +  procedure = ecircle_btree_lt,
   1.436 +  commutator = >>>,
   1.437 +  negator = >>>=,
   1.438 +  restrict = scalarltsel,
   1.439 +  join = scalarltjoinsel
   1.440 +);
   1.441 +
   1.442 +CREATE OPERATOR <<<= (
   1.443 +  leftarg = ecircle,
   1.444 +  rightarg = ecircle,
   1.445 +  procedure = ecircle_btree_le,
   1.446 +  commutator = >>>=,
   1.447 +  negator = >>>,
   1.448 +  restrict = scalarltsel,
   1.449 +  join = scalarltjoinsel
   1.450 +);
   1.451 +
   1.452 +CREATE OPERATOR = (
   1.453 +  leftarg = ecircle,
   1.454 +  rightarg = ecircle,
   1.455 +  procedure = ecircle_btree_eq,
   1.456 +  commutator = =,
   1.457 +  negator = <>,
   1.458 +  restrict = eqsel,
   1.459 +  join = eqjoinsel,
   1.460 +  merges
   1.461 +);
   1.462 +
   1.463 +CREATE OPERATOR <> (
   1.464 +  leftarg = ecircle,
   1.465 +  rightarg = ecircle,
   1.466 +  procedure = ecircle_btree_eq,
   1.467 +  commutator = <>,
   1.468 +  negator = =,
   1.469 +  restrict = neqsel,
   1.470 +  join = neqjoinsel
   1.471 +);
   1.472 +
   1.473 +CREATE OPERATOR >>>= (
   1.474 +  leftarg = ecircle,
   1.475 +  rightarg = ecircle,
   1.476 +  procedure = ecircle_btree_ge,
   1.477 +  commutator = <<<=,
   1.478 +  negator = <<<,
   1.479 +  restrict = scalargtsel,
   1.480 +  join = scalargtjoinsel
   1.481 +);
   1.482 +
   1.483 +CREATE OPERATOR >>> (
   1.484 +  leftarg = ecircle,
   1.485 +  rightarg = ecircle,
   1.486 +  procedure = ecircle_btree_gt,
   1.487 +  commutator = <<<,
   1.488 +  negator = <<<=,
   1.489 +  restrict = scalargtsel,
   1.490 +  join = scalargtjoinsel
   1.491 +);
   1.492 +
   1.493 +CREATE FUNCTION ecircle_btree_cmp(ecircle, ecircle)
   1.494 +  RETURNS int4
   1.495 +  LANGUAGE C IMMUTABLE STRICT
   1.496 +  AS '$libdir/latlon-v0004', 'pgl_btree_ecircle_cmp';
   1.497 +
   1.498 +CREATE OPERATOR CLASS ecircle_btree_ops
   1.499 +  DEFAULT FOR TYPE ecircle USING btree AS
   1.500 +  OPERATOR 1 <<< ,
   1.501 +  OPERATOR 2 <<<= ,
   1.502 +  OPERATOR 3 = ,
   1.503 +  OPERATOR 4 >>>= ,
   1.504 +  OPERATOR 5 >>> ,
   1.505 +  FUNCTION 1 ecircle_btree_cmp(ecircle, ecircle);
   1.506 +
   1.507 +-- end of B-tree support for ecircle
   1.508 +
   1.509 +
   1.510 +----------------
   1.511 +-- type casts --
   1.512 +----------------
   1.513 +
   1.514 +CREATE FUNCTION cast_epoint_to_ebox(epoint)
   1.515 +  RETURNS ebox
   1.516 +  LANGUAGE C IMMUTABLE STRICT
   1.517 +  AS '$libdir/latlon-v0004', 'pgl_epoint_to_ebox';
   1.518 +
   1.519 +CREATE CAST (epoint AS ebox) WITH FUNCTION cast_epoint_to_ebox(epoint);
   1.520 +
   1.521 +CREATE FUNCTION cast_epoint_to_ecircle(epoint)
   1.522 +  RETURNS ecircle
   1.523 +  LANGUAGE C IMMUTABLE STRICT
   1.524 +  AS '$libdir/latlon-v0004', 'pgl_epoint_to_ecircle';
   1.525 +
   1.526 +CREATE CAST (epoint AS ecircle) WITH FUNCTION cast_epoint_to_ecircle(epoint);
   1.527 +
   1.528 +CREATE FUNCTION cast_epoint_to_ecluster(epoint)
   1.529 +  RETURNS ecluster
   1.530 +  LANGUAGE C IMMUTABLE STRICT
   1.531 +  AS '$libdir/latlon-v0004', 'pgl_epoint_to_ecluster';
   1.532 +
   1.533 +CREATE CAST (epoint AS ecluster) WITH FUNCTION cast_epoint_to_ecluster(epoint);
   1.534 +
   1.535 +CREATE FUNCTION cast_ebox_to_ecluster(ebox)
   1.536 +  RETURNS ecluster
   1.537 +  LANGUAGE C IMMUTABLE STRICT
   1.538 +  AS '$libdir/latlon-v0004', 'pgl_ebox_to_ecluster';
   1.539 +
   1.540 +CREATE CAST (ebox AS ecluster) WITH FUNCTION cast_ebox_to_ecluster(ebox);
   1.541 +
   1.542 +
   1.543 +---------------------------
   1.544 +-- constructor functions --
   1.545 +---------------------------
   1.546 +
   1.547 +CREATE FUNCTION epoint(float8, float8)
   1.548 +  RETURNS epoint
   1.549 +  LANGUAGE C IMMUTABLE STRICT
   1.550 +  AS '$libdir/latlon-v0004', 'pgl_create_epoint';
   1.551 +
   1.552 +CREATE FUNCTION epoint_latlon(float8, float8)
   1.553 +  RETURNS epoint
   1.554 +  LANGUAGE SQL IMMUTABLE STRICT AS $$
   1.555 +    SELECT epoint($1, $2)
   1.556 +  $$;
   1.557 +
   1.558 +CREATE FUNCTION epoint_lonlat(float8, float8)
   1.559 +  RETURNS epoint
   1.560 +  LANGUAGE SQL IMMUTABLE STRICT AS $$
   1.561 +    SELECT epoint($2, $1)
   1.562 +  $$;
   1.563 +
   1.564 +CREATE FUNCTION empty_ebox()
   1.565 +  RETURNS ebox
   1.566 +  LANGUAGE C IMMUTABLE STRICT
   1.567 +  AS '$libdir/latlon-v0004', 'pgl_create_empty_ebox';
   1.568 +
   1.569 +CREATE FUNCTION ebox(float8, float8, float8, float8)
   1.570 +  RETURNS ebox
   1.571 +  LANGUAGE C IMMUTABLE STRICT
   1.572 +  AS '$libdir/latlon-v0004', 'pgl_create_ebox';
   1.573 +
   1.574 +CREATE FUNCTION ebox(epoint, epoint)
   1.575 +  RETURNS ebox
   1.576 +  LANGUAGE C IMMUTABLE STRICT
   1.577 +  AS '$libdir/latlon-v0004', 'pgl_create_ebox_from_epoints';
   1.578 +
   1.579 +CREATE FUNCTION ecircle(float8, float8, float8)
   1.580 +  RETURNS ecircle
   1.581 +  LANGUAGE C IMMUTABLE STRICT
   1.582 +  AS '$libdir/latlon-v0004', 'pgl_create_ecircle';
   1.583 +
   1.584 +CREATE FUNCTION ecircle(epoint, float8)
   1.585 +  RETURNS ecircle
   1.586 +  LANGUAGE C IMMUTABLE STRICT
   1.587 +  AS '$libdir/latlon-v0004', 'pgl_create_ecircle_from_epoint';
   1.588 +
   1.589 +CREATE FUNCTION ecluster_concat(ecluster[])
   1.590 +  RETURNS ecluster
   1.591 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.592 +    SELECT array_to_string($1, ' ')::ecluster
   1.593 +  $$;
   1.594 +
   1.595 +CREATE FUNCTION ecluster_concat(ecluster, ecluster)
   1.596 +  RETURNS ecluster
   1.597 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.598 +    SELECT ($1::text || ' ' || $2::text)::ecluster
   1.599 +  $$;
   1.600 +
   1.601 +CREATE FUNCTION ecluster_create_multipoint(epoint[])
   1.602 +  RETURNS ecluster
   1.603 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.604 +    SELECT
   1.605 +      array_to_string(array_agg('point (' || unnest || ')'), ' ')::ecluster
   1.606 +    FROM unnest($1)
   1.607 +  $$;
   1.608 +
   1.609 +CREATE FUNCTION ecluster_create_path(epoint[])
   1.610 +  RETURNS ecluster
   1.611 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.612 +    SELECT CASE WHEN "str" = '' THEN 'empty'::ecluster ELSE
   1.613 +      ('path (' || array_to_string($1, ' ') || ')')::ecluster
   1.614 +    END
   1.615 +    FROM array_to_string($1, ' ') AS "str"
   1.616 +  $$;
   1.617 +
   1.618 +CREATE FUNCTION ecluster_create_outline(epoint[])
   1.619 +  RETURNS ecluster
   1.620 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.621 +    SELECT CASE WHEN "str" = '' THEN 'empty'::ecluster ELSE
   1.622 +      ('outline (' || array_to_string($1, ' ') || ')')::ecluster
   1.623 +    END
   1.624 +    FROM array_to_string($1, ' ') AS "str"
   1.625 +  $$;
   1.626 +
   1.627 +CREATE FUNCTION ecluster_create_polygon(epoint[])
   1.628 +  RETURNS ecluster
   1.629 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.630 +    SELECT CASE WHEN "str" = '' THEN 'empty'::ecluster ELSE
   1.631 +      ('polygon (' || array_to_string($1, ' ') || ')')::ecluster
   1.632 +    END
   1.633 +    FROM array_to_string($1, ' ') AS "str"
   1.634 +  $$;
   1.635 +
   1.636 +
   1.637 +----------------------
   1.638 +-- getter functions --
   1.639 +----------------------
   1.640 +
   1.641 +CREATE FUNCTION latitude(epoint)
   1.642 +  RETURNS float8
   1.643 +  LANGUAGE C IMMUTABLE STRICT
   1.644 +  AS '$libdir/latlon-v0004', 'pgl_epoint_lat';
   1.645 +
   1.646 +CREATE FUNCTION longitude(epoint)
   1.647 +  RETURNS float8
   1.648 +  LANGUAGE C IMMUTABLE STRICT
   1.649 +  AS '$libdir/latlon-v0004', 'pgl_epoint_lon';
   1.650 +
   1.651 +CREATE FUNCTION min_latitude(ebox)
   1.652 +  RETURNS float8
   1.653 +  LANGUAGE C IMMUTABLE STRICT
   1.654 +  AS '$libdir/latlon-v0004', 'pgl_ebox_lat_min';
   1.655 +
   1.656 +CREATE FUNCTION max_latitude(ebox)
   1.657 +  RETURNS float8
   1.658 +  LANGUAGE C IMMUTABLE STRICT
   1.659 +  AS '$libdir/latlon-v0004', 'pgl_ebox_lat_max';
   1.660 +
   1.661 +CREATE FUNCTION min_longitude(ebox)
   1.662 +  RETURNS float8
   1.663 +  LANGUAGE C IMMUTABLE STRICT
   1.664 +  AS '$libdir/latlon-v0004', 'pgl_ebox_lon_min';
   1.665 +
   1.666 +CREATE FUNCTION max_longitude(ebox)
   1.667 +  RETURNS float8
   1.668 +  LANGUAGE C IMMUTABLE STRICT
   1.669 +  AS '$libdir/latlon-v0004', 'pgl_ebox_lon_max';
   1.670 +
   1.671 +CREATE FUNCTION center(ecircle)
   1.672 +  RETURNS epoint
   1.673 +  LANGUAGE C IMMUTABLE STRICT
   1.674 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_center';
   1.675 +
   1.676 +CREATE FUNCTION radius(ecircle)
   1.677 +  RETURNS float8
   1.678 +  LANGUAGE C IMMUTABLE STRICT
   1.679 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_radius';
   1.680 +
   1.681 +CREATE FUNCTION ecluster_extract_points(ecluster)
   1.682 +  RETURNS SETOF epoint
   1.683 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.684 +    SELECT "match"[2]::epoint
   1.685 +    FROM regexp_matches($1::text, e'(^| )point \\(([^)]+)\\)', 'g') AS "match"
   1.686 +  $$;
   1.687 +
   1.688 +CREATE FUNCTION ecluster_extract_paths(ecluster)
   1.689 +  RETURNS SETOF epoint[]
   1.690 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.691 +    SELECT (
   1.692 +      SELECT array_agg("m2"[1]::epoint)
   1.693 +      FROM regexp_matches("m1"[2], e'[^ ]+ [^ ]+', 'g') AS "m2"
   1.694 +    )
   1.695 +    FROM regexp_matches($1::text, e'(^| )path \\(([^)]+)\\)', 'g') AS "m1"
   1.696 +  $$;
   1.697 +
   1.698 +CREATE FUNCTION ecluster_extract_outlines(ecluster)
   1.699 +  RETURNS SETOF epoint[]
   1.700 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.701 +    SELECT (
   1.702 +      SELECT array_agg("m2"[1]::epoint)
   1.703 +      FROM regexp_matches("m1"[2], e'[^ ]+ [^ ]+', 'g') AS "m2"
   1.704 +    )
   1.705 +    FROM regexp_matches($1::text, e'(^| )outline \\(([^)]+)\\)', 'g') AS "m1"
   1.706 +  $$;
   1.707 +
   1.708 +CREATE FUNCTION ecluster_extract_polygons(ecluster)
   1.709 +  RETURNS SETOF epoint[]
   1.710 +  LANGUAGE sql IMMUTABLE STRICT AS $$
   1.711 +    SELECT (
   1.712 +      SELECT array_agg("m2"[1]::epoint)
   1.713 +      FROM regexp_matches("m1"[2], e'[^ ]+ [^ ]+', 'g') AS "m2"
   1.714 +    )
   1.715 +    FROM regexp_matches($1::text, e'(^| )polygon \\(([^)]+)\\)', 'g') AS "m1"
   1.716 +  $$;
   1.717 +
   1.718 +
   1.719 +---------------
   1.720 +-- operators --
   1.721 +---------------
   1.722 +
   1.723 +CREATE FUNCTION epoint_ebox_overlap_proc(epoint, ebox)
   1.724 +  RETURNS boolean
   1.725 +  LANGUAGE C IMMUTABLE STRICT
   1.726 +  AS '$libdir/latlon-v0004', 'pgl_epoint_ebox_overlap';
   1.727 +
   1.728 +CREATE FUNCTION epoint_ecircle_overlap_proc(epoint, ecircle)
   1.729 +  RETURNS boolean
   1.730 +  LANGUAGE C IMMUTABLE STRICT
   1.731 +  AS '$libdir/latlon-v0004', 'pgl_epoint_ecircle_overlap';
   1.732 +
   1.733 +CREATE FUNCTION epoint_ecluster_overlap_proc(epoint, ecluster)
   1.734 +  RETURNS boolean
   1.735 +  LANGUAGE C IMMUTABLE STRICT
   1.736 +  AS '$libdir/latlon-v0004', 'pgl_epoint_ecluster_overlap';
   1.737 +
   1.738 +CREATE FUNCTION epoint_ecluster_may_overlap_proc(epoint, ecluster)
   1.739 +  RETURNS boolean
   1.740 +  LANGUAGE C IMMUTABLE STRICT
   1.741 +  AS '$libdir/latlon-v0004', 'pgl_epoint_ecluster_may_overlap';
   1.742 +
   1.743 +CREATE FUNCTION ebox_overlap_proc(ebox, ebox)
   1.744 +  RETURNS boolean
   1.745 +  LANGUAGE C IMMUTABLE STRICT
   1.746 +  AS '$libdir/latlon-v0004', 'pgl_ebox_overlap';
   1.747 +
   1.748 +CREATE FUNCTION ebox_ecircle_may_overlap_proc(ebox, ecircle)
   1.749 +  RETURNS boolean
   1.750 +  LANGUAGE C IMMUTABLE STRICT
   1.751 +  AS '$libdir/latlon-v0004', 'pgl_ebox_ecircle_may_overlap';
   1.752 +
   1.753 +CREATE FUNCTION ebox_ecluster_may_overlap_proc(ebox, ecluster)
   1.754 +  RETURNS boolean
   1.755 +  LANGUAGE C IMMUTABLE STRICT
   1.756 +  AS '$libdir/latlon-v0004', 'pgl_ebox_ecluster_may_overlap';
   1.757 +
   1.758 +CREATE FUNCTION ecircle_overlap_proc(ecircle, ecircle)
   1.759 +  RETURNS boolean
   1.760 +  LANGUAGE C IMMUTABLE STRICT
   1.761 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_overlap';
   1.762 +
   1.763 +CREATE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster)
   1.764 +  RETURNS boolean
   1.765 +  LANGUAGE C IMMUTABLE STRICT
   1.766 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_ecluster_overlap';
   1.767 +
   1.768 +CREATE FUNCTION ecircle_ecluster_may_overlap_proc(ecircle, ecluster)
   1.769 +  RETURNS boolean
   1.770 +  LANGUAGE C IMMUTABLE STRICT
   1.771 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_ecluster_may_overlap';
   1.772 +
   1.773 +CREATE FUNCTION ecluster_may_overlap_proc(ecluster, ecluster)
   1.774 +  RETURNS boolean
   1.775 +  LANGUAGE C IMMUTABLE STRICT
   1.776 +  AS '$libdir/latlon-v0004', 'pgl_ecluster_may_overlap';
   1.777 +
   1.778 +CREATE FUNCTION epoint_distance_proc(epoint, epoint)
   1.779 +  RETURNS float8
   1.780 +  LANGUAGE C IMMUTABLE STRICT
   1.781 +  AS '$libdir/latlon-v0004', 'pgl_epoint_distance';
   1.782 +
   1.783 +CREATE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)
   1.784 +  RETURNS float8
   1.785 +  LANGUAGE C IMMUTABLE STRICT
   1.786 +  AS '$libdir/latlon-v0004', 'pgl_epoint_ecircle_distance';
   1.787 +
   1.788 +CREATE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)
   1.789 +  RETURNS float8
   1.790 +  LANGUAGE C IMMUTABLE STRICT
   1.791 +  AS '$libdir/latlon-v0004', 'pgl_epoint_ecluster_distance';
   1.792 +
   1.793 +CREATE FUNCTION ecircle_distance_proc(ecircle, ecircle)
   1.794 +  RETURNS float8
   1.795 +  LANGUAGE C IMMUTABLE STRICT
   1.796 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_distance';
   1.797 +
   1.798 +CREATE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)
   1.799 +  RETURNS float8
   1.800 +  LANGUAGE C IMMUTABLE STRICT
   1.801 +  AS '$libdir/latlon-v0004', 'pgl_ecircle_ecluster_distance';
   1.802 +
   1.803 +CREATE OPERATOR && (
   1.804 +  leftarg = epoint,
   1.805 +  rightarg = ebox,
   1.806 +  procedure = epoint_ebox_overlap_proc,
   1.807 +  commutator = &&,
   1.808 +  restrict = areasel,
   1.809 +  join = areajoinsel
   1.810 +);
   1.811 +
   1.812 +CREATE FUNCTION epoint_ebox_overlap_commutator(ebox, epoint)
   1.813 +  RETURNS boolean
   1.814 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 && $1';
   1.815 +
   1.816 +CREATE OPERATOR && (
   1.817 +  leftarg = ebox,
   1.818 +  rightarg = epoint,
   1.819 +  procedure = epoint_ebox_overlap_commutator,
   1.820 +  commutator = &&,
   1.821 +  restrict = areasel,
   1.822 +  join = areajoinsel
   1.823 +);
   1.824 +
   1.825 +CREATE OPERATOR && (
   1.826 +  leftarg = epoint,
   1.827 +  rightarg = ecircle,
   1.828 +  procedure = epoint_ecircle_overlap_proc,
   1.829 +  commutator = &&,
   1.830 +  restrict = areasel,
   1.831 +  join = areajoinsel
   1.832 +);
   1.833 +
   1.834 +CREATE FUNCTION epoint_ecircle_overlap_commutator(ecircle, epoint)
   1.835 +  RETURNS boolean
   1.836 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 && $1';
   1.837 +
   1.838 +CREATE OPERATOR && (
   1.839 +  leftarg = ecircle,
   1.840 +  rightarg = epoint,
   1.841 +  procedure = epoint_ecircle_overlap_commutator,
   1.842 +  commutator = &&,
   1.843 +  restrict = areasel,
   1.844 +  join = areajoinsel
   1.845 +);
   1.846 +
   1.847 +CREATE OPERATOR && (
   1.848 +  leftarg = epoint,
   1.849 +  rightarg = ecluster,
   1.850 +  procedure = epoint_ecluster_overlap_proc,
   1.851 +  commutator = &&,
   1.852 +  restrict = areasel,
   1.853 +  join = areajoinsel
   1.854 +);
   1.855 +
   1.856 +CREATE FUNCTION epoint_ecluster_overlap_commutator(ecluster, epoint)
   1.857 +  RETURNS boolean
   1.858 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 && $1';
   1.859 +
   1.860 +CREATE OPERATOR && (
   1.861 +  leftarg = ecluster,
   1.862 +  rightarg = epoint,
   1.863 +  procedure = epoint_ecluster_overlap_commutator,
   1.864 +  commutator = &&,
   1.865 +  restrict = areasel,
   1.866 +  join = areajoinsel
   1.867 +);
   1.868 +
   1.869 +CREATE OPERATOR && (
   1.870 +  leftarg = ebox,
   1.871 +  rightarg = ebox,
   1.872 +  procedure = ebox_overlap_proc,
   1.873 +  commutator = &&,
   1.874 +  restrict = areasel,
   1.875 +  join = areajoinsel
   1.876 +);
   1.877 +
   1.878 +CREATE OPERATOR && (
   1.879 +  leftarg = ecircle,
   1.880 +  rightarg = ecircle,
   1.881 +  procedure = ecircle_overlap_proc,
   1.882 +  commutator = &&,
   1.883 +  restrict = areasel,
   1.884 +  join = areajoinsel
   1.885 +);
   1.886 +
   1.887 +CREATE OPERATOR && (
   1.888 +  leftarg = ecircle,
   1.889 +  rightarg = ecluster,
   1.890 +  procedure = ecircle_ecluster_overlap_proc,
   1.891 +  commutator = &&,
   1.892 +  restrict = areasel,
   1.893 +  join = areajoinsel
   1.894 +);
   1.895 +
   1.896 +CREATE FUNCTION ecircle_ecluster_overlap_commutator(ecluster, ecircle)
   1.897 +  RETURNS boolean
   1.898 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 && $1';
   1.899 +
   1.900 +CREATE OPERATOR && (
   1.901 +  leftarg = ecluster,
   1.902 +  rightarg = ecircle,
   1.903 +  procedure = ecircle_ecluster_overlap_commutator,
   1.904 +  commutator = &&,
   1.905 +  restrict = areasel,
   1.906 +  join = areajoinsel
   1.907 +);
   1.908 +
   1.909 +CREATE OPERATOR &&+ (
   1.910 +  leftarg = epoint,
   1.911 +  rightarg = ecluster,
   1.912 +  procedure = epoint_ecluster_may_overlap_proc,
   1.913 +  commutator = &&+,
   1.914 +  restrict = areasel,
   1.915 +  join = areajoinsel
   1.916 +);
   1.917 +
   1.918 +CREATE FUNCTION epoint_ecluster_may_overlap_commutator(ecluster, epoint)
   1.919 +  RETURNS boolean
   1.920 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';
   1.921 +
   1.922 +CREATE OPERATOR &&+ (
   1.923 +  leftarg = ecluster,
   1.924 +  rightarg = epoint,
   1.925 +  procedure = epoint_ecluster_may_overlap_commutator,
   1.926 +  commutator = &&+,
   1.927 +  restrict = areasel,
   1.928 +  join = areajoinsel
   1.929 +);
   1.930 +
   1.931 +CREATE OPERATOR &&+ (
   1.932 +  leftarg = ebox,
   1.933 +  rightarg = ecircle,
   1.934 +  procedure = ebox_ecircle_may_overlap_proc,
   1.935 +  commutator = &&+,
   1.936 +  restrict = areasel,
   1.937 +  join = areajoinsel
   1.938 +);
   1.939 +
   1.940 +CREATE FUNCTION ebox_ecircle_may_overlap_commutator(ecircle, ebox)
   1.941 +  RETURNS boolean
   1.942 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';
   1.943 +
   1.944 +CREATE OPERATOR &&+ (
   1.945 +  leftarg = ecircle,
   1.946 +  rightarg = ebox,
   1.947 +  procedure = ebox_ecircle_may_overlap_commutator,
   1.948 +  commutator = &&+,
   1.949 +  restrict = areasel,
   1.950 +  join = areajoinsel
   1.951 +);
   1.952 +
   1.953 +CREATE OPERATOR &&+ (
   1.954 +  leftarg = ebox,
   1.955 +  rightarg = ecluster,
   1.956 +  procedure = ebox_ecluster_may_overlap_proc,
   1.957 +  commutator = &&+,
   1.958 +  restrict = areasel,
   1.959 +  join = areajoinsel
   1.960 +);
   1.961 +
   1.962 +CREATE FUNCTION ebox_ecluster_may_overlap_commutator(ecluster, ebox)
   1.963 +  RETURNS boolean
   1.964 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';
   1.965 +
   1.966 +CREATE OPERATOR &&+ (
   1.967 +  leftarg = ecluster,
   1.968 +  rightarg = ebox,
   1.969 +  procedure = ebox_ecluster_may_overlap_commutator,
   1.970 +  commutator = &&+,
   1.971 +  restrict = areasel,
   1.972 +  join = areajoinsel
   1.973 +);
   1.974 +
   1.975 +CREATE OPERATOR &&+ (
   1.976 +  leftarg = ecircle,
   1.977 +  rightarg = ecluster,
   1.978 +  procedure = ecircle_ecluster_may_overlap_proc,
   1.979 +  commutator = &&+,
   1.980 +  restrict = areasel,
   1.981 +  join = areajoinsel
   1.982 +);
   1.983 +
   1.984 +CREATE FUNCTION ecircle_ecluster_may_overlap_commutator(ecluster, ecircle)
   1.985 +  RETURNS boolean
   1.986 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 &&+ $1';
   1.987 +
   1.988 +CREATE OPERATOR &&+ (
   1.989 +  leftarg = ecluster,
   1.990 +  rightarg = ecircle,
   1.991 +  procedure = ecircle_ecluster_may_overlap_commutator,
   1.992 +  commutator = &&+,
   1.993 +  restrict = areasel,
   1.994 +  join = areajoinsel
   1.995 +);
   1.996 +
   1.997 +CREATE OPERATOR &&+ (
   1.998 +  leftarg = ecluster,
   1.999 +  rightarg = ecluster,
  1.1000 +  procedure = ecluster_may_overlap_proc,
  1.1001 +  commutator = &&+,
  1.1002 +  restrict = areasel,
  1.1003 +  join = areajoinsel
  1.1004 +);
  1.1005 +
  1.1006 +CREATE OPERATOR <-> (
  1.1007 +  leftarg = epoint,
  1.1008 +  rightarg = epoint,
  1.1009 +  procedure = epoint_distance_proc,
  1.1010 +  commutator = <->
  1.1011 +);
  1.1012 +
  1.1013 +CREATE OPERATOR <-> (
  1.1014 +  leftarg = epoint,
  1.1015 +  rightarg = ecircle,
  1.1016 +  procedure = epoint_ecircle_distance_proc,
  1.1017 +  commutator = <->
  1.1018 +);
  1.1019 +
  1.1020 +CREATE FUNCTION epoint_ecircle_distance_commutator(ecircle, epoint)
  1.1021 +  RETURNS float8
  1.1022 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 <-> $1';
  1.1023 +
  1.1024 +CREATE OPERATOR <-> (
  1.1025 +  leftarg = ecircle,
  1.1026 +  rightarg = epoint,
  1.1027 +  procedure = epoint_ecircle_distance_commutator,
  1.1028 +  commutator = <->
  1.1029 +);
  1.1030 +
  1.1031 +CREATE OPERATOR <-> (
  1.1032 +  leftarg = epoint,
  1.1033 +  rightarg = ecluster,
  1.1034 +  procedure = epoint_ecluster_distance_proc,
  1.1035 +  commutator = <->
  1.1036 +);
  1.1037 +
  1.1038 +CREATE FUNCTION epoint_ecluster_distance_commutator(ecluster, epoint)
  1.1039 +  RETURNS float8
  1.1040 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 <-> $1';
  1.1041 +
  1.1042 +CREATE OPERATOR <-> (
  1.1043 +  leftarg = ecluster,
  1.1044 +  rightarg = epoint,
  1.1045 +  procedure = epoint_ecluster_distance_commutator,
  1.1046 +  commutator = <->
  1.1047 +);
  1.1048 +
  1.1049 +CREATE OPERATOR <-> (
  1.1050 +  leftarg = ecircle,
  1.1051 +  rightarg = ecircle,
  1.1052 +  procedure = ecircle_distance_proc,
  1.1053 +  commutator = <->
  1.1054 +);
  1.1055 +
  1.1056 +CREATE OPERATOR <-> (
  1.1057 +  leftarg = ecircle,
  1.1058 +  rightarg = ecluster,
  1.1059 +  procedure = ecircle_ecluster_distance_proc,
  1.1060 +  commutator = <->
  1.1061 +);
  1.1062 +
  1.1063 +CREATE FUNCTION ecircle_ecluster_distance_commutator(ecluster, ecircle)
  1.1064 +  RETURNS float8
  1.1065 +  LANGUAGE sql IMMUTABLE AS 'SELECT $2 <-> $1';
  1.1066 +
  1.1067 +CREATE OPERATOR <-> (
  1.1068 +  leftarg = ecluster,
  1.1069 +  rightarg = ecircle,
  1.1070 +  procedure = ecircle_ecluster_distance_commutator,
  1.1071 +  commutator = <->
  1.1072 +);
  1.1073 +
  1.1074 +
  1.1075 +----------------
  1.1076 +-- GiST index --
  1.1077 +----------------
  1.1078 +
  1.1079 +CREATE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal)
  1.1080 +  RETURNS boolean
  1.1081 +  LANGUAGE C STRICT
  1.1082 +  AS '$libdir/latlon-v0004', 'pgl_gist_consistent';
  1.1083 +
  1.1084 +CREATE FUNCTION pgl_gist_union(internal, internal)
  1.1085 +  RETURNS internal
  1.1086 +  LANGUAGE C STRICT
  1.1087 +  AS '$libdir/latlon-v0004', 'pgl_gist_union';
  1.1088 +
  1.1089 +CREATE FUNCTION pgl_gist_compress_epoint(internal)
  1.1090 +  RETURNS internal
  1.1091 +  LANGUAGE C STRICT
  1.1092 +  AS '$libdir/latlon-v0004', 'pgl_gist_compress_epoint';
  1.1093 +
  1.1094 +CREATE FUNCTION pgl_gist_compress_ecircle(internal)
  1.1095 +  RETURNS internal
  1.1096 +  LANGUAGE C STRICT
  1.1097 +  AS '$libdir/latlon-v0004', 'pgl_gist_compress_ecircle';
  1.1098 +
  1.1099 +CREATE FUNCTION pgl_gist_compress_ecluster(internal)
  1.1100 +  RETURNS internal
  1.1101 +  LANGUAGE C STRICT
  1.1102 +  AS '$libdir/latlon-v0004', 'pgl_gist_compress_ecluster';
  1.1103 +
  1.1104 +CREATE FUNCTION pgl_gist_decompress(internal)
  1.1105 +  RETURNS internal
  1.1106 +  LANGUAGE C STRICT
  1.1107 +  AS '$libdir/latlon-v0004', 'pgl_gist_decompress';
  1.1108 +
  1.1109 +CREATE FUNCTION pgl_gist_penalty(internal, internal, internal)
  1.1110 +  RETURNS internal
  1.1111 +  LANGUAGE C STRICT
  1.1112 +  AS '$libdir/latlon-v0004', 'pgl_gist_penalty';
  1.1113 +
  1.1114 +CREATE FUNCTION pgl_gist_picksplit(internal, internal)
  1.1115 +  RETURNS internal
  1.1116 +  LANGUAGE C STRICT
  1.1117 +  AS '$libdir/latlon-v0004', 'pgl_gist_picksplit';
  1.1118 +
  1.1119 +CREATE FUNCTION pgl_gist_same(internal, internal, internal)
  1.1120 +  RETURNS internal
  1.1121 +  LANGUAGE C STRICT
  1.1122 +  AS '$libdir/latlon-v0004', 'pgl_gist_same';
  1.1123 +
  1.1124 +CREATE FUNCTION pgl_gist_distance(internal, internal, smallint, oid)
  1.1125 +  RETURNS internal
  1.1126 +  LANGUAGE C STRICT
  1.1127 +  AS '$libdir/latlon-v0004', 'pgl_gist_distance';
  1.1128 +
  1.1129 +CREATE OPERATOR CLASS epoint_ops
  1.1130 +  DEFAULT FOR TYPE epoint USING gist AS
  1.1131 +  OPERATOR  11 = ,
  1.1132 +  OPERATOR  22 &&  (epoint, ebox),
  1.1133 +  OPERATOR  23 &&  (epoint, ecircle),
  1.1134 +  OPERATOR  24 &&  (epoint, ecluster),
  1.1135 +  OPERATOR 124 &&+ (epoint, ecluster),
  1.1136 +  OPERATOR  31 <-> (epoint, epoint) FOR ORDER BY float_ops,
  1.1137 +  OPERATOR  33 <-> (epoint, ecircle) FOR ORDER BY float_ops,
  1.1138 +  OPERATOR  34 <-> (epoint, ecluster) FOR ORDER BY float_ops,
  1.1139 +  FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
  1.1140 +  FUNCTION 2 pgl_gist_union(internal, internal),
  1.1141 +  FUNCTION 3 pgl_gist_compress_epoint(internal),
  1.1142 +  FUNCTION 4 pgl_gist_decompress(internal),
  1.1143 +  FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
  1.1144 +  FUNCTION 6 pgl_gist_picksplit(internal, internal),
  1.1145 +  FUNCTION 7 pgl_gist_same(internal, internal, internal),
  1.1146 +  FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
  1.1147 +  STORAGE ekey_point;
  1.1148 +
  1.1149 +CREATE OPERATOR CLASS ecircle_ops
  1.1150 +  DEFAULT FOR TYPE ecircle USING gist AS
  1.1151 +  OPERATOR  13 = ,
  1.1152 +  OPERATOR  21 &&  (ecircle, epoint),
  1.1153 +  OPERATOR 122 &&+ (ecircle, ebox),
  1.1154 +  OPERATOR  23 &&  (ecircle, ecircle),
  1.1155 +  OPERATOR  24 &&  (ecircle, ecluster),
  1.1156 +  OPERATOR 124 &&+ (ecircle, ecluster),
  1.1157 +  OPERATOR  31 <-> (ecircle, epoint) FOR ORDER BY float_ops,
  1.1158 +  OPERATOR  33 <-> (ecircle, ecircle) FOR ORDER BY float_ops,
  1.1159 +  OPERATOR  34 <-> (ecircle, ecluster) FOR ORDER BY float_ops,
  1.1160 +  FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
  1.1161 +  FUNCTION 2 pgl_gist_union(internal, internal),
  1.1162 +  FUNCTION 3 pgl_gist_compress_ecircle(internal),
  1.1163 +  FUNCTION 4 pgl_gist_decompress(internal),
  1.1164 +  FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
  1.1165 +  FUNCTION 6 pgl_gist_picksplit(internal, internal),
  1.1166 +  FUNCTION 7 pgl_gist_same(internal, internal, internal),
  1.1167 +  FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
  1.1168 +  STORAGE ekey_area;
  1.1169 +
  1.1170 +CREATE OPERATOR CLASS ecluster_ops
  1.1171 +  DEFAULT FOR TYPE ecluster USING gist AS
  1.1172 +  OPERATOR  21 &&  (ecluster, epoint),
  1.1173 +  OPERATOR 121 &&+ (ecluster, epoint),
  1.1174 +  OPERATOR 122 &&+ (ecluster, ebox),
  1.1175 +  OPERATOR  23 &&  (ecluster, ecircle),
  1.1176 +  OPERATOR 123 &&+ (ecluster, ecircle),
  1.1177 +  OPERATOR 124 &&+ (ecluster, ecluster),
  1.1178 +  FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
  1.1179 +  FUNCTION 2 pgl_gist_union(internal, internal),
  1.1180 +  FUNCTION 3 pgl_gist_compress_ecluster(internal),
  1.1181 +  FUNCTION 4 pgl_gist_decompress(internal),
  1.1182 +  FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
  1.1183 +  FUNCTION 6 pgl_gist_picksplit(internal, internal),
  1.1184 +  FUNCTION 7 pgl_gist_same(internal, internal, internal),
  1.1185 +  FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
  1.1186 +  STORAGE ekey_area;
  1.1187 +
  1.1188 +
  1.1189 +---------------------
  1.1190 +-- alias functions --
  1.1191 +---------------------
  1.1192 +
  1.1193 +CREATE FUNCTION distance(epoint, epoint)
  1.1194 +  RETURNS float8
  1.1195 +  LANGUAGE sql IMMUTABLE AS 'SELECT $1 <-> $2';
  1.1196 +
  1.1197 +CREATE FUNCTION distance(ecluster, epoint)
  1.1198 +  RETURNS float8
  1.1199 +  LANGUAGE sql IMMUTABLE AS 'SELECT $1 <-> $2';
  1.1200 +
  1.1201 +CREATE FUNCTION distance_within(epoint, epoint, float8)
  1.1202 +  RETURNS boolean
  1.1203 +  LANGUAGE sql IMMUTABLE AS 'SELECT $1 && ecircle($2, $3)';
  1.1204 +
  1.1205 +CREATE FUNCTION distance_within(ecluster, epoint, float8)
  1.1206 +  RETURNS boolean
  1.1207 +  LANGUAGE sql IMMUTABLE AS 'SELECT $1 && ecircle($2, $3)';
  1.1208 +
  1.1209 +
  1.1210 +--------------------------------
  1.1211 +-- other data storage formats --
  1.1212 +--------------------------------
  1.1213 +
  1.1214 +CREATE FUNCTION coords_to_epoint(float8, float8, text = 'epoint_lonlat')
  1.1215 +  RETURNS epoint
  1.1216 +  LANGUAGE plpgsql IMMUTABLE STRICT AS $$
  1.1217 +    DECLARE
  1.1218 +      "result" epoint;
  1.1219 +    BEGIN
  1.1220 +      IF $3 = 'epoint_lonlat' THEN
  1.1221 +        -- avoid dynamic command execution for better performance
  1.1222 +        RETURN epoint($2, $1);
  1.1223 +      END IF;
  1.1224 +      IF $3 = 'epoint' OR $3 = 'epoint_latlon' THEN
  1.1225 +        -- avoid dynamic command execution for better performance
  1.1226 +        RETURN epoint($1, $2);
  1.1227 +      END IF;
  1.1228 +      EXECUTE 'SELECT ' || $3 || '($1, $2)' INTO STRICT "result" USING $1, $2;
  1.1229 +      RETURN "result";
  1.1230 +    END;
  1.1231 +  $$;
  1.1232 +
  1.1233 +CREATE FUNCTION GeoJSON_to_epoint(jsonb, text = 'epoint_lonlat')
  1.1234 +  RETURNS epoint
  1.1235 +  LANGUAGE sql IMMUTABLE STRICT AS $$
  1.1236 +    SELECT CASE
  1.1237 +    WHEN $1->>'type' = 'Point' THEN
  1.1238 +      coords_to_epoint(
  1.1239 +        ($1->'coordinates'->>1)::float8,
  1.1240 +        ($1->'coordinates'->>0)::float8,
  1.1241 +        $2
  1.1242 +      )
  1.1243 +    WHEN $1->>'type' = 'Feature' THEN
  1.1244 +      GeoJSON_to_epoint($1->'geometry', $2)
  1.1245 +    ELSE
  1.1246 +      NULL
  1.1247 +    END
  1.1248 +  $$;
  1.1249 +
  1.1250 +CREATE FUNCTION GeoJSON_to_ecluster(jsonb, text = 'epoint_lonlat')
  1.1251 +  RETURNS ecluster
  1.1252 +  LANGUAGE sql IMMUTABLE STRICT AS $$
  1.1253 +    SELECT CASE $1->>'type'
  1.1254 +    WHEN 'Point' THEN
  1.1255 +      coords_to_epoint(
  1.1256 +        ($1->'coordinates'->>1)::float8,
  1.1257 +        ($1->'coordinates'->>0)::float8,
  1.1258 +        $2
  1.1259 +      )::ecluster
  1.1260 +    WHEN 'MultiPoint' THEN
  1.1261 +      ( SELECT ecluster_create_multipoint(array_agg(
  1.1262 +          coords_to_epoint(
  1.1263 +            ("coord"->>1)::float8,
  1.1264 +            ("coord"->>0)::float8,
  1.1265 +            $2
  1.1266 +          )
  1.1267 +        ))
  1.1268 +        FROM jsonb_array_elements($1->'coordinates') AS "coord"
  1.1269 +      )
  1.1270 +    WHEN 'LineString' THEN
  1.1271 +      ( SELECT ecluster_create_path(array_agg(
  1.1272 +          coords_to_epoint(
  1.1273 +            ("coord"->>1)::float8,
  1.1274 +            ("coord"->>0)::float8,
  1.1275 +            $2
  1.1276 +          )
  1.1277 +        ))
  1.1278 +        FROM jsonb_array_elements($1->'coordinates') AS "coord"
  1.1279 +      )
  1.1280 +    WHEN 'MultiLineString' THEN
  1.1281 +      ( SELECT ecluster_concat(array_agg(
  1.1282 +          ( SELECT ecluster_create_path(array_agg(
  1.1283 +              coords_to_epoint(
  1.1284 +                ("coord"->>1)::float8,
  1.1285 +                ("coord"->>0)::float8,
  1.1286 +                $2
  1.1287 +              )
  1.1288 +            ))
  1.1289 +            FROM jsonb_array_elements("coord_array") AS "coord"
  1.1290 +          )
  1.1291 +        ))
  1.1292 +        FROM jsonb_array_elements($1->'coordinates') AS "coord_array"
  1.1293 +      )
  1.1294 +    WHEN 'Polygon' THEN
  1.1295 +      ( SELECT ecluster_concat(array_agg(
  1.1296 +          ( SELECT ecluster_create_polygon(array_agg(
  1.1297 +              coords_to_epoint(
  1.1298 +                ("coord"->>1)::float8,
  1.1299 +                ("coord"->>0)::float8,
  1.1300 +                $2
  1.1301 +              )
  1.1302 +            ))
  1.1303 +            FROM jsonb_array_elements("coord_array") AS "coord"
  1.1304 +          )
  1.1305 +        ))
  1.1306 +        FROM jsonb_array_elements($1->'coordinates') AS "coord_array"
  1.1307 +      )
  1.1308 +    WHEN 'MultiPolygon' THEN
  1.1309 +      ( SELECT ecluster_concat(array_agg(
  1.1310 +          ( SELECT ecluster_concat(array_agg(
  1.1311 +              ( SELECT ecluster_create_polygon(array_agg(
  1.1312 +                  coords_to_epoint(
  1.1313 +                    ("coord"->>1)::float8,
  1.1314 +                    ("coord"->>0)::float8,
  1.1315 +                    $2
  1.1316 +                  )
  1.1317 +                ))
  1.1318 +                FROM jsonb_array_elements("coord_array") AS "coord"
  1.1319 +              )
  1.1320 +            ))
  1.1321 +            FROM jsonb_array_elements("coord_array_array") AS "coord_array"
  1.1322 +          )
  1.1323 +        ))
  1.1324 +        FROM jsonb_array_elements($1->'coordinates') AS "coord_array_array"
  1.1325 +      )
  1.1326 +    WHEN 'Feature' THEN
  1.1327 +      GeoJSON_to_ecluster($1->'geometry', $2)
  1.1328 +    WHEN 'FeatureCollection' THEN
  1.1329 +      ( SELECT ecluster_concat(array_agg(
  1.1330 +          GeoJSON_to_ecluster("feature", $2)
  1.1331 +        ))
  1.1332 +        FROM jsonb_array_elements($1->'features') AS "feature"
  1.1333 +      )
  1.1334 +    ELSE
  1.1335 +      NULL
  1.1336 +    END
  1.1337 +  $$;
  1.1338 +