pgLatLon
diff latlon--0.1--0.2.sql @ 4:8f79d4a1cdc1
New version 0.2 and update script from version 0.1
author | jbe |
---|---|
date | Mon Aug 22 21:51:33 2016 +0200 (2016-08-22) |
parents | latlon--0.1.sql@3b70e93cc07d |
children |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/latlon--0.1--0.2.sql Mon Aug 22 21:51:33 2016 +0200 1.3 @@ -0,0 +1,391 @@ 1.4 + 1.5 +CREATE OR REPLACE FUNCTION ekey_point_in_dummy(cstring) 1.6 + RETURNS ekey_point 1.7 + LANGUAGE C IMMUTABLE STRICT 1.8 + AS '$libdir/latlon-v0002', 'pgl_notimpl'; 1.9 + 1.10 +CREATE OR REPLACE FUNCTION ekey_point_out_dummy(ekey_point) 1.11 + RETURNS cstring 1.12 + LANGUAGE C IMMUTABLE STRICT 1.13 + AS '$libdir/latlon-v0002', 'pgl_notimpl'; 1.14 + 1.15 +CREATE OR REPLACE FUNCTION ekey_area_in_dummy(cstring) 1.16 + RETURNS ekey_area 1.17 + LANGUAGE C IMMUTABLE STRICT 1.18 + AS '$libdir/latlon-v0002', 'pgl_notimpl'; 1.19 + 1.20 +CREATE OR REPLACE FUNCTION ekey_area_out_dummy(ekey_area) 1.21 + RETURNS cstring 1.22 + LANGUAGE C IMMUTABLE STRICT 1.23 + AS '$libdir/latlon-v0002', 'pgl_notimpl'; 1.24 + 1.25 +CREATE OR REPLACE FUNCTION epoint_in(cstring) 1.26 + RETURNS epoint 1.27 + LANGUAGE C IMMUTABLE STRICT 1.28 + AS '$libdir/latlon-v0002', 'pgl_epoint_in'; 1.29 + 1.30 +CREATE OR REPLACE FUNCTION ebox_in(cstring) 1.31 + RETURNS ebox 1.32 + LANGUAGE C IMMUTABLE STRICT 1.33 + AS '$libdir/latlon-v0002', 'pgl_ebox_in'; 1.34 + 1.35 +CREATE OR REPLACE FUNCTION ecircle_in(cstring) 1.36 + RETURNS ecircle 1.37 + LANGUAGE C IMMUTABLE STRICT 1.38 + AS '$libdir/latlon-v0002', 'pgl_ecircle_in'; 1.39 + 1.40 +CREATE OR REPLACE FUNCTION ecluster_in(cstring) 1.41 + RETURNS ecluster 1.42 + LANGUAGE C IMMUTABLE STRICT 1.43 + AS '$libdir/latlon-v0002', 'pgl_ecluster_in'; 1.44 + 1.45 +CREATE OR REPLACE FUNCTION epoint_out(epoint) 1.46 + RETURNS cstring 1.47 + LANGUAGE C IMMUTABLE STRICT 1.48 + AS '$libdir/latlon-v0002', 'pgl_epoint_out'; 1.49 + 1.50 +CREATE OR REPLACE FUNCTION ebox_out(ebox) 1.51 + RETURNS cstring 1.52 + LANGUAGE C IMMUTABLE STRICT 1.53 + AS '$libdir/latlon-v0002', 'pgl_ebox_out'; 1.54 + 1.55 +CREATE OR REPLACE FUNCTION ecircle_out(ecircle) 1.56 + RETURNS cstring 1.57 + LANGUAGE C IMMUTABLE STRICT 1.58 + AS '$libdir/latlon-v0002', 'pgl_ecircle_out'; 1.59 + 1.60 +CREATE OR REPLACE FUNCTION ecluster_out(ecluster) 1.61 + RETURNS cstring 1.62 + LANGUAGE C IMMUTABLE STRICT 1.63 + AS '$libdir/latlon-v0002', 'pgl_ecluster_out'; 1.64 + 1.65 +CREATE OR REPLACE FUNCTION epoint_recv(internal) 1.66 + RETURNS epoint 1.67 + LANGUAGE C IMMUTABLE STRICT 1.68 + AS '$libdir/latlon-v0002', 'pgl_epoint_recv'; 1.69 + 1.70 +CREATE OR REPLACE FUNCTION ebox_recv(internal) 1.71 + RETURNS ebox 1.72 + LANGUAGE C IMMUTABLE STRICT 1.73 + AS '$libdir/latlon-v0002', 'pgl_ebox_recv'; 1.74 + 1.75 +CREATE OR REPLACE FUNCTION ecircle_recv(internal) 1.76 + RETURNS ecircle 1.77 + LANGUAGE C IMMUTABLE STRICT 1.78 + AS '$libdir/latlon-v0002', 'pgl_ecircle_recv'; 1.79 + 1.80 +CREATE OR REPLACE FUNCTION epoint_send(epoint) 1.81 + RETURNS bytea 1.82 + LANGUAGE C IMMUTABLE STRICT 1.83 + AS '$libdir/latlon-v0002', 'pgl_epoint_send'; 1.84 + 1.85 +CREATE OR REPLACE FUNCTION ebox_send(ebox) 1.86 + RETURNS bytea 1.87 + LANGUAGE C IMMUTABLE STRICT 1.88 + AS '$libdir/latlon-v0002', 'pgl_ebox_send'; 1.89 + 1.90 +CREATE OR REPLACE FUNCTION ecircle_send(ecircle) 1.91 + RETURNS bytea 1.92 + LANGUAGE C IMMUTABLE STRICT 1.93 + AS '$libdir/latlon-v0002', 'pgl_ecircle_send'; 1.94 + 1.95 +CREATE OR REPLACE FUNCTION epoint_btree_lt(epoint, epoint) 1.96 + RETURNS boolean 1.97 + LANGUAGE C IMMUTABLE STRICT 1.98 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_lt'; 1.99 + 1.100 +CREATE OR REPLACE FUNCTION epoint_btree_le(epoint, epoint) 1.101 + RETURNS boolean 1.102 + LANGUAGE C IMMUTABLE STRICT 1.103 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_le'; 1.104 + 1.105 +CREATE OR REPLACE FUNCTION epoint_btree_eq(epoint, epoint) 1.106 + RETURNS boolean 1.107 + LANGUAGE C IMMUTABLE STRICT 1.108 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_eq'; 1.109 + 1.110 +CREATE OR REPLACE FUNCTION epoint_btree_ne(epoint, epoint) 1.111 + RETURNS boolean 1.112 + LANGUAGE C IMMUTABLE STRICT 1.113 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_ne'; 1.114 + 1.115 +CREATE OR REPLACE FUNCTION epoint_btree_ge(epoint, epoint) 1.116 + RETURNS boolean 1.117 + LANGUAGE C IMMUTABLE STRICT 1.118 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_ge'; 1.119 + 1.120 +CREATE OR REPLACE FUNCTION epoint_btree_gt(epoint, epoint) 1.121 + RETURNS boolean 1.122 + LANGUAGE C IMMUTABLE STRICT 1.123 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_gt'; 1.124 + 1.125 +CREATE OR REPLACE FUNCTION epoint_btree_cmp(epoint, epoint) 1.126 + RETURNS int4 1.127 + LANGUAGE C IMMUTABLE STRICT 1.128 + AS '$libdir/latlon-v0002', 'pgl_btree_epoint_cmp'; 1.129 + 1.130 +CREATE OR REPLACE FUNCTION ebox_btree_lt(ebox, ebox) 1.131 + RETURNS boolean 1.132 + LANGUAGE C IMMUTABLE STRICT 1.133 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_lt'; 1.134 + 1.135 +CREATE OR REPLACE FUNCTION ebox_btree_le(ebox, ebox) 1.136 + RETURNS boolean 1.137 + LANGUAGE C IMMUTABLE STRICT 1.138 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_le'; 1.139 + 1.140 +CREATE OR REPLACE FUNCTION ebox_btree_eq(ebox, ebox) 1.141 + RETURNS boolean 1.142 + LANGUAGE C IMMUTABLE STRICT 1.143 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_eq'; 1.144 + 1.145 +CREATE OR REPLACE FUNCTION ebox_btree_ne(ebox, ebox) 1.146 + RETURNS boolean 1.147 + LANGUAGE C IMMUTABLE STRICT 1.148 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_ne'; 1.149 + 1.150 +CREATE OR REPLACE FUNCTION ebox_btree_ge(ebox, ebox) 1.151 + RETURNS boolean 1.152 + LANGUAGE C IMMUTABLE STRICT 1.153 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_ge'; 1.154 + 1.155 +CREATE OR REPLACE FUNCTION ebox_btree_gt(ebox, ebox) 1.156 + RETURNS boolean 1.157 + LANGUAGE C IMMUTABLE STRICT 1.158 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_gt'; 1.159 + 1.160 +CREATE OR REPLACE FUNCTION ebox_btree_cmp(ebox, ebox) 1.161 + RETURNS int4 1.162 + LANGUAGE C IMMUTABLE STRICT 1.163 + AS '$libdir/latlon-v0002', 'pgl_btree_ebox_cmp'; 1.164 + 1.165 +CREATE OR REPLACE FUNCTION ecircle_btree_lt(ecircle, ecircle) 1.166 + RETURNS boolean 1.167 + LANGUAGE C IMMUTABLE STRICT 1.168 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_lt'; 1.169 + 1.170 +CREATE OR REPLACE FUNCTION ecircle_btree_le(ecircle, ecircle) 1.171 + RETURNS boolean 1.172 + LANGUAGE C IMMUTABLE STRICT 1.173 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_le'; 1.174 + 1.175 +CREATE OR REPLACE FUNCTION ecircle_btree_eq(ecircle, ecircle) 1.176 + RETURNS boolean 1.177 + LANGUAGE C IMMUTABLE STRICT 1.178 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_eq'; 1.179 + 1.180 +CREATE OR REPLACE FUNCTION ecircle_btree_ne(ecircle, ecircle) 1.181 + RETURNS boolean 1.182 + LANGUAGE C IMMUTABLE STRICT 1.183 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_ne'; 1.184 + 1.185 +CREATE OR REPLACE FUNCTION ecircle_btree_ge(ecircle, ecircle) 1.186 + RETURNS boolean 1.187 + LANGUAGE C IMMUTABLE STRICT 1.188 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_ge'; 1.189 + 1.190 +CREATE OR REPLACE FUNCTION ecircle_btree_gt(ecircle, ecircle) 1.191 + RETURNS boolean 1.192 + LANGUAGE C IMMUTABLE STRICT 1.193 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_gt'; 1.194 + 1.195 +CREATE OR REPLACE FUNCTION ecircle_btree_cmp(ecircle, ecircle) 1.196 + RETURNS int4 1.197 + LANGUAGE C IMMUTABLE STRICT 1.198 + AS '$libdir/latlon-v0002', 'pgl_btree_ecircle_cmp'; 1.199 + 1.200 +CREATE OR REPLACE FUNCTION cast_epoint_to_ebox(epoint) 1.201 + RETURNS ebox 1.202 + LANGUAGE C IMMUTABLE STRICT 1.203 + AS '$libdir/latlon-v0002', 'pgl_epoint_to_ebox'; 1.204 + 1.205 +CREATE OR REPLACE FUNCTION cast_epoint_to_ecircle(epoint) 1.206 + RETURNS ecircle 1.207 + LANGUAGE C IMMUTABLE STRICT 1.208 + AS '$libdir/latlon-v0002', 'pgl_epoint_to_ecircle'; 1.209 + 1.210 +CREATE OR REPLACE FUNCTION cast_epoint_to_ecluster(epoint) 1.211 + RETURNS ecluster 1.212 + LANGUAGE C IMMUTABLE STRICT 1.213 + AS '$libdir/latlon-v0002', 'pgl_epoint_to_ecluster'; 1.214 + 1.215 +CREATE OR REPLACE FUNCTION cast_ebox_to_ecluster(ebox) 1.216 + RETURNS ecluster 1.217 + LANGUAGE C IMMUTABLE STRICT 1.218 + AS '$libdir/latlon-v0002', 'pgl_ebox_to_ecluster'; 1.219 + 1.220 +CREATE OR REPLACE FUNCTION epoint(float8, float8) 1.221 + RETURNS epoint 1.222 + LANGUAGE C IMMUTABLE STRICT 1.223 + AS '$libdir/latlon-v0002', 'pgl_create_epoint'; 1.224 + 1.225 +CREATE OR REPLACE FUNCTION empty_ebox() 1.226 + RETURNS ebox 1.227 + LANGUAGE C IMMUTABLE STRICT 1.228 + AS '$libdir/latlon-v0002', 'pgl_create_empty_ebox'; 1.229 + 1.230 +CREATE OR REPLACE FUNCTION ebox(float8, float8, float8, float8) 1.231 + RETURNS ebox 1.232 + LANGUAGE C IMMUTABLE STRICT 1.233 + AS '$libdir/latlon-v0002', 'pgl_create_ebox'; 1.234 + 1.235 +CREATE OR REPLACE FUNCTION ebox(epoint, epoint) 1.236 + RETURNS ebox 1.237 + LANGUAGE C IMMUTABLE STRICT 1.238 + AS '$libdir/latlon-v0002', 'pgl_create_ebox_from_epoints'; 1.239 + 1.240 +CREATE OR REPLACE FUNCTION ecircle(float8, float8, float8) 1.241 + RETURNS ecircle 1.242 + LANGUAGE C IMMUTABLE STRICT 1.243 + AS '$libdir/latlon-v0002', 'pgl_create_ecircle'; 1.244 + 1.245 +CREATE OR REPLACE FUNCTION ecircle(epoint, float8) 1.246 + RETURNS ecircle 1.247 + LANGUAGE C IMMUTABLE STRICT 1.248 + AS '$libdir/latlon-v0002', 'pgl_create_ecircle_from_epoint'; 1.249 + 1.250 +CREATE OR REPLACE FUNCTION latitude(epoint) 1.251 + RETURNS float8 1.252 + LANGUAGE C IMMUTABLE STRICT 1.253 + AS '$libdir/latlon-v0002', 'pgl_epoint_lat'; 1.254 + 1.255 +CREATE OR REPLACE FUNCTION longitude(epoint) 1.256 + RETURNS float8 1.257 + LANGUAGE C IMMUTABLE STRICT 1.258 + AS '$libdir/latlon-v0002', 'pgl_epoint_lon'; 1.259 + 1.260 +CREATE OR REPLACE FUNCTION min_latitude(ebox) 1.261 + RETURNS float8 1.262 + LANGUAGE C IMMUTABLE STRICT 1.263 + AS '$libdir/latlon-v0002', 'pgl_ebox_lat_min'; 1.264 + 1.265 +CREATE OR REPLACE FUNCTION max_latitude(ebox) 1.266 + RETURNS float8 1.267 + LANGUAGE C IMMUTABLE STRICT 1.268 + AS '$libdir/latlon-v0002', 'pgl_ebox_lat_max'; 1.269 + 1.270 +CREATE OR REPLACE FUNCTION min_longitude(ebox) 1.271 + RETURNS float8 1.272 + LANGUAGE C IMMUTABLE STRICT 1.273 + AS '$libdir/latlon-v0002', 'pgl_ebox_lon_min'; 1.274 + 1.275 +CREATE OR REPLACE FUNCTION max_longitude(ebox) 1.276 + RETURNS float8 1.277 + LANGUAGE C IMMUTABLE STRICT 1.278 + AS '$libdir/latlon-v0002', 'pgl_ebox_lon_max'; 1.279 + 1.280 +CREATE OR REPLACE FUNCTION center(ecircle) 1.281 + RETURNS epoint 1.282 + LANGUAGE C IMMUTABLE STRICT 1.283 + AS '$libdir/latlon-v0002', 'pgl_ecircle_center'; 1.284 + 1.285 +CREATE OR REPLACE FUNCTION radius(ecircle) 1.286 + RETURNS float8 1.287 + LANGUAGE C IMMUTABLE STRICT 1.288 + AS '$libdir/latlon-v0002', 'pgl_ecircle_radius'; 1.289 + 1.290 +CREATE OR REPLACE FUNCTION epoint_ebox_overlap_proc(epoint, ebox) 1.291 + RETURNS boolean 1.292 + LANGUAGE C IMMUTABLE STRICT 1.293 + AS '$libdir/latlon-v0002', 'pgl_epoint_ebox_overlap'; 1.294 + 1.295 +CREATE OR REPLACE FUNCTION epoint_ecircle_overlap_proc(epoint, ecircle) 1.296 + RETURNS boolean 1.297 + LANGUAGE C IMMUTABLE STRICT 1.298 + AS '$libdir/latlon-v0002', 'pgl_epoint_ecircle_overlap'; 1.299 + 1.300 +CREATE OR REPLACE FUNCTION epoint_ecluster_overlap_proc(epoint, ecluster) 1.301 + RETURNS boolean 1.302 + LANGUAGE C IMMUTABLE STRICT 1.303 + AS '$libdir/latlon-v0002', 'pgl_epoint_ecluster_overlap'; 1.304 + 1.305 +CREATE OR REPLACE FUNCTION ebox_overlap_proc(ebox, ebox) 1.306 + RETURNS boolean 1.307 + LANGUAGE C IMMUTABLE STRICT 1.308 + AS '$libdir/latlon-v0002', 'pgl_ebox_overlap'; 1.309 + 1.310 +CREATE OR REPLACE FUNCTION ecircle_overlap_proc(ecircle, ecircle) 1.311 + RETURNS boolean 1.312 + LANGUAGE C IMMUTABLE STRICT 1.313 + AS '$libdir/latlon-v0002', 'pgl_ecircle_overlap'; 1.314 + 1.315 +CREATE OR REPLACE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster) 1.316 + RETURNS boolean 1.317 + LANGUAGE C IMMUTABLE STRICT 1.318 + AS '$libdir/latlon-v0002', 'pgl_ecircle_ecluster_overlap'; 1.319 + 1.320 +CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint) 1.321 + RETURNS float8 1.322 + LANGUAGE C IMMUTABLE STRICT 1.323 + AS '$libdir/latlon-v0002', 'pgl_epoint_distance'; 1.324 + 1.325 +CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle) 1.326 + RETURNS float8 1.327 + LANGUAGE C IMMUTABLE STRICT 1.328 + AS '$libdir/latlon-v0002', 'pgl_epoint_ecircle_distance'; 1.329 + 1.330 +CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster) 1.331 + RETURNS float8 1.332 + LANGUAGE C IMMUTABLE STRICT 1.333 + AS '$libdir/latlon-v0002', 'pgl_epoint_ecluster_distance'; 1.334 + 1.335 +CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle) 1.336 + RETURNS float8 1.337 + LANGUAGE C IMMUTABLE STRICT 1.338 + AS '$libdir/latlon-v0002', 'pgl_ecircle_distance'; 1.339 + 1.340 +CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster) 1.341 + RETURNS float8 1.342 + LANGUAGE C IMMUTABLE STRICT 1.343 + AS '$libdir/latlon-v0002', 'pgl_ecircle_ecluster_distance'; 1.344 + 1.345 +CREATE OR REPLACE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal) 1.346 + RETURNS boolean 1.347 + LANGUAGE C STRICT 1.348 + AS '$libdir/latlon-v0002', 'pgl_gist_consistent'; 1.349 + 1.350 +CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal) 1.351 + RETURNS internal 1.352 + LANGUAGE C STRICT 1.353 + AS '$libdir/latlon-v0002', 'pgl_gist_union'; 1.354 + 1.355 +CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal) 1.356 + RETURNS internal 1.357 + LANGUAGE C STRICT 1.358 + AS '$libdir/latlon-v0002', 'pgl_gist_compress_epoint'; 1.359 + 1.360 +CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal) 1.361 + RETURNS internal 1.362 + LANGUAGE C STRICT 1.363 + AS '$libdir/latlon-v0002', 'pgl_gist_compress_ecircle'; 1.364 + 1.365 +CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal) 1.366 + RETURNS internal 1.367 + LANGUAGE C STRICT 1.368 + AS '$libdir/latlon-v0002', 'pgl_gist_compress_ecluster'; 1.369 + 1.370 +CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal) 1.371 + RETURNS internal 1.372 + LANGUAGE C STRICT 1.373 + AS '$libdir/latlon-v0002', 'pgl_gist_decompress'; 1.374 + 1.375 +CREATE OR REPLACE FUNCTION pgl_gist_penalty(internal, internal, internal) 1.376 + RETURNS internal 1.377 + LANGUAGE C STRICT 1.378 + AS '$libdir/latlon-v0002', 'pgl_gist_penalty'; 1.379 + 1.380 +CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal) 1.381 + RETURNS internal 1.382 + LANGUAGE C STRICT 1.383 + AS '$libdir/latlon-v0002', 'pgl_gist_picksplit'; 1.384 + 1.385 +CREATE OR REPLACE FUNCTION pgl_gist_same(internal, internal, internal) 1.386 + RETURNS internal 1.387 + LANGUAGE C STRICT 1.388 + AS '$libdir/latlon-v0002', 'pgl_gist_same'; 1.389 + 1.390 +CREATE OR REPLACE FUNCTION pgl_gist_distance(internal, internal, smallint, oid) 1.391 + RETURNS internal 1.392 + LANGUAGE C STRICT 1.393 + AS '$libdir/latlon-v0002', 'pgl_gist_distance'; 1.394 +