aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2005-01-26 08:10:08 +0000
committerNeil Conway <neilc@samurai.com>2005-01-26 08:10:08 +0000
commitdb78e53fac8251f446d1ecf49c8c81c240c1381e (patch)
tree9f4df61b485fc394575ad45e14740d6b11803bd9
parent6508bf52549fb4dc248c757a754b195bd24aa508 (diff)
downloadpostgresql-db78e53fac8251f446d1ecf49c8c81c240c1381e.tar.gz
postgresql-db78e53fac8251f446d1ecf49c8c81c240c1381e.zip
Mark the text_soundex() function as "strict", to avoid crashing on NULL
input. Also, may as well mark it "cacheable" as well. From Kris Jurka.
-rw-r--r--contrib/fuzzystrmatch/fuzzystrmatch.sql.in2
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
index c548b8ba9f2..36f0a06d445 100644
--- a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
+++ b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
@@ -17,4 +17,4 @@ LANGUAGE 'C' WITH (iscachable, isstrict);
CREATE FUNCTION text_soundex(text) RETURNS text
AS 'MODULE_PATHNAME', 'soundex'
-LANGUAGE 'C';
+LANGUAGE 'C' WITH (iscachable, isstrict);