diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-06-11 18:30:03 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-06-11 18:30:03 +0000 |
| commit | d94582f4f8a06e08c8b054d332174165de6e40a6 (patch) | |
| tree | 517d261c6a655c96d4300c99445a048fc2e7daa2 /contrib/pg_trgm/pg_trgm.sql.in | |
| parent | 4c8175278f12e1cca5bd4e1c5826e130a7b99bd2 (diff) | |
| download | postgresql-d94582f4f8a06e08c8b054d332174165de6e40a6.tar.gz | |
Mark contrib's GiST and GIN opclass support functions as STRICT, for safety.
(Note: GiST penalty functions could possibly be non-strict, but none are at
present.)
Diffstat (limited to 'contrib/pg_trgm/pg_trgm.sql.in')
| -rw-r--r-- | contrib/pg_trgm/pg_trgm.sql.in | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/contrib/pg_trgm/pg_trgm.sql.in b/contrib/pg_trgm/pg_trgm.sql.in index f59ea1ba85..5396b52b1b 100644 --- a/contrib/pg_trgm/pg_trgm.sql.in +++ b/contrib/pg_trgm/pg_trgm.sql.in @@ -1,4 +1,4 @@ -/* $PostgreSQL: pgsql/contrib/pg_trgm/pg_trgm.sql.in,v 1.9 2009/03/25 22:19:01 tgl Exp $ */ +/* $PostgreSQL: pgsql/contrib/pg_trgm/pg_trgm.sql.in,v 1.10 2009/06/11 18:30:03 tgl Exp $ */ -- Adjust this setting to control where the objects get created. SET search_path = public; @@ -58,37 +58,37 @@ CREATE TYPE gtrgm ( CREATE OR REPLACE FUNCTION gtrgm_consistent(internal,text,int,oid,internal) RETURNS bool AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gtrgm_compress(internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gtrgm_decompress(internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gtrgm_penalty(internal,internal,internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C STRICT IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gtrgm_picksplit(internal, internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gtrgm_union(bytea, internal) RETURNS _int4 AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gtrgm_same(gtrgm, gtrgm, internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; -- create the operator class for gist CREATE OPERATOR CLASS gist_trgm_ops @@ -108,17 +108,17 @@ AS CREATE OR REPLACE FUNCTION gin_extract_trgm(text, internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gin_extract_trgm(text, internal, int2, internal, internal) RETURNS internal AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; CREATE OR REPLACE FUNCTION gin_trgm_consistent(internal, int2, text, int4, internal, internal) RETURNS bool AS 'MODULE_PATHNAME' -LANGUAGE C IMMUTABLE; +LANGUAGE C IMMUTABLE STRICT; -- create the operator class for gin CREATE OPERATOR CLASS gin_trgm_ops |
