From 05eddb709181cb04f8fd2bd3e5eeebf3a325dd2b Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sun, 10 Aug 2014 17:15:10 +0000 Subject: [PATCH] #2890 missing availability info for geography operators git-svn-id: http://svn.osgeo.org/postgis/trunk@12881 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/geography.sql.in | 15 +++++++++++++-- 1 file changed, 13 insertions(+), 2 deletions(-) diff --git a/postgis/geography.sql.in b/postgis/geography.sql.in index b184552c1..852e1e110 100644 --- a/postgis/geography.sql.in +++ b/postgis/geography.sql.in @@ -270,32 +270,37 @@ CREATE OPERATOR CLASS gist_geography_ops -- For sorting and grouping -- Availability: 1.5.0 -- ---------- ---------- ---------- ---------- ---------- ---------- ---------- - +-- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_lt(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_lt' LANGUAGE 'c' IMMUTABLE STRICT; +-- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_le(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_le' LANGUAGE 'c' IMMUTABLE STRICT; +-- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_gt(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_gt' LANGUAGE 'c' IMMUTABLE STRICT; +-- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_ge(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_ge' LANGUAGE 'c' IMMUTABLE STRICT; +-- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_eq(geography, geography) RETURNS bool AS 'MODULE_PATHNAME', 'geography_eq' LANGUAGE 'c' IMMUTABLE STRICT; +-- Availability: 1.5.0 CREATE OR REPLACE FUNCTION geography_cmp(geography, geography) RETURNS integer AS 'MODULE_PATHNAME', 'geography_cmp' @@ -304,36 +309,42 @@ CREATE OR REPLACE FUNCTION geography_cmp(geography, geography) -- -- Sorting operators for Btree -- - +-- Availability: 1.5.0 CREATE OPERATOR < ( LEFTARG = geography, RIGHTARG = geography, PROCEDURE = geography_lt, COMMUTATOR = '>', NEGATOR = '>=', RESTRICT = contsel, JOIN = contjoinsel ); +-- Availability: 1.5.0 CREATE OPERATOR <= ( LEFTARG = geography, RIGHTARG = geography, PROCEDURE = geography_le, COMMUTATOR = '>=', NEGATOR = '>', RESTRICT = contsel, JOIN = contjoinsel ); +-- Availability: 1.5.0 CREATE OPERATOR = ( LEFTARG = geography, RIGHTARG = geography, PROCEDURE = geography_eq, COMMUTATOR = '=', -- we might implement a faster negator here RESTRICT = contsel, JOIN = contjoinsel ); +-- Availability: 1.5.0 CREATE OPERATOR >= ( LEFTARG = geography, RIGHTARG = geography, PROCEDURE = geography_ge, COMMUTATOR = '<=', NEGATOR = '<', RESTRICT = contsel, JOIN = contjoinsel ); + +-- Availability: 1.5.0 CREATE OPERATOR > ( LEFTARG = geography, RIGHTARG = geography, PROCEDURE = geography_gt, COMMUTATOR = '<', NEGATOR = '<=', RESTRICT = contsel, JOIN = contjoinsel ); +-- Availability: 1.5.0 CREATE OPERATOR CLASS btree_geography_ops DEFAULT FOR TYPE geography USING btree AS OPERATOR 1 < , -- 2.40.0