diff options
| author | Bruce Momjian | 2001-08-10 14:34:28 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2001-08-10 14:34:28 +0000 |
| commit | 13923be7c8799c4f8ce0f5a04e4cd06c5b696f25 (patch) | |
| tree | c5a648d9e97754f4a99195d6de48b470a6326253 /contrib/intarray | |
| parent | 77a69a2ed165c31a981ac553f56c7b43e12d9ab5 (diff) | |
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
Diffstat (limited to 'contrib/intarray')
| -rw-r--r-- | contrib/intarray/_int.sql.in | 16 |
1 files changed, 8 insertions, 8 deletions
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'; |
