From 13923be7c8799c4f8ce0f5a04e4cd06c5b696f25 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 10 Aug 2001 14:34:28 +0000 Subject: 1. null-safe interface to GiST (as proposed in http://fts.postgresql.org/db/mw/msg.html?mid=1028327) 2. support for 'pass-by-value' arguments - to test this we used special opclass for int4 with values in range [0-2^15] More testing will be done after resolving problem with index_formtuple and implementation of B-tree using GiST 3. small patch to contrib modules (seg,cube,rtree_gist,intarray) - mark functions as 'isstrict' where needed. Oleg Bartunov --- contrib/intarray/_int.sql.in | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'contrib/intarray') diff --git a/contrib/intarray/_int.sql.in b/contrib/intarray/_int.sql.in index 2214bef21f1..a07013337b9 100644 --- a/contrib/intarray/_int.sql.in +++ b/contrib/intarray/_int.sql.in @@ -9,7 +9,7 @@ BEGIN TRANSACTION; -- Comparison methods CREATE FUNCTION _int_contains(_int4, _int4) RETURNS bool - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); INSERT INTO pg_description (objoid, description) SELECT oid, 'contains'::text @@ -17,7 +17,7 @@ INSERT INTO pg_description (objoid, description) WHERE proname = '_int_contains'::name; CREATE FUNCTION _int_contained(_int4, _int4) RETURNS bool - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); INSERT INTO pg_description (objoid, description) SELECT oid, 'contained in'::text @@ -25,7 +25,7 @@ INSERT INTO pg_description (objoid, description) WHERE proname = '_int_contained'::name; CREATE FUNCTION _int_overlap(_int4, _int4) RETURNS bool - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); INSERT INTO pg_description (objoid, description) SELECT oid, 'overlaps'::text @@ -33,7 +33,7 @@ INSERT INTO pg_description (objoid, description) WHERE proname = '_int_overlap'::name; CREATE FUNCTION _int_same(_int4, _int4) RETURNS bool - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); INSERT INTO pg_description (objoid, description) SELECT oid, 'same as'::text @@ -41,7 +41,7 @@ INSERT INTO pg_description (objoid, description) WHERE proname = '_int_same'::name; CREATE FUNCTION _int_different(_int4, _int4) RETURNS bool - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); INSERT INTO pg_description (objoid, description) SELECT oid, 'different'::text @@ -51,10 +51,10 @@ INSERT INTO pg_description (objoid, description) -- support routines for indexing CREATE FUNCTION _int_union(_int4, _int4) RETURNS _int4 - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); CREATE FUNCTION _int_inter(_int4, _int4) RETURNS _int4 - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); -- -- OPERATORS @@ -223,7 +223,7 @@ CREATE FUNCTION g_intbig_decompress(opaque) RETURNS opaque AS 'MODULE_PATHNAME' LANGUAGE 'c'; CREATE FUNCTION g_intbig_penalty(opaque,opaque,opaque) RETURNS opaque - AS 'MODULE_PATHNAME' LANGUAGE 'c'; + AS 'MODULE_PATHNAME' LANGUAGE 'c' with (isstrict); CREATE FUNCTION g_intbig_picksplit(opaque, opaque) RETURNS opaque AS 'MODULE_PATHNAME' LANGUAGE 'c'; -- cgit v1.2.3