summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane2007-12-09 02:22:46 +0000
committerTom Lane2007-12-09 02:22:46 +0000
commitcb1ab30fdc3b44a7d34ccf9cdaa82d46dd6427c1 (patch)
tree9d1b450666efa01d077d1d6132855650a40c842d
parent9fd88436470482fc030d4c2328977b3cf66f01f1 (diff)
Fix completely-bogus volatility markings on pg_trgm functions.
-rw-r--r--contrib/pg_trgm/pg_trgm.sql.in8
1 files changed, 4 insertions, 4 deletions
diff --git a/contrib/pg_trgm/pg_trgm.sql.in b/contrib/pg_trgm/pg_trgm.sql.in
index ab6c62d3737..963e6f091df 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.6 2007/11/13 04:24:28 momjian Exp $ */
+/* $PostgreSQL: pgsql/contrib/pg_trgm/pg_trgm.sql.in,v 1.7 2007/12/09 02:22:46 tgl Exp $ */
-- Adjust this setting to control where the objects get created.
SET search_path = public;
@@ -6,12 +6,12 @@ SET search_path = public;
CREATE OR REPLACE FUNCTION set_limit(float4)
RETURNS float4
AS 'MODULE_PATHNAME'
-LANGUAGE C STRICT IMMUTABLE;
+LANGUAGE C STRICT VOLATILE;
CREATE OR REPLACE FUNCTION show_limit()
RETURNS float4
AS 'MODULE_PATHNAME'
-LANGUAGE C STRICT IMMUTABLE;
+LANGUAGE C STRICT STABLE;
CREATE OR REPLACE FUNCTION show_trgm(text)
RETURNS _text
@@ -26,7 +26,7 @@ LANGUAGE C STRICT IMMUTABLE;
CREATE OR REPLACE FUNCTION similarity_op(text,text)
RETURNS bool
AS 'MODULE_PATHNAME'
-LANGUAGE C STRICT IMMUTABLE;
+LANGUAGE C STRICT STABLE;
CREATE OPERATOR % (
LEFTARG = text,