summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2005-01-26 08:20:40 +0000
committerNeil Conway <neilc@samurai.com>2005-01-26 08:20:40 +0000
commit38ab95f70329979c54dff619e541ed339b88cde1 (patch)
tree8b0af13e569bfbc3becdd0a4ecfad7270b5a5c8b
parenta23133a4d7f4f4523f2aa8c1cd5f48e0f85d4137 (diff)
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 3dc2888f40a..8664d88c60d 100644
--- a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
+++ b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in
@@ -19,4 +19,4 @@ LANGUAGE 'C' WITH (iscachable, isstrict);
CREATE FUNCTION text_soundex(text) RETURNS text
AS 'MODULE_PATHNAME', 'soundex'
-LANGUAGE 'C';
+LANGUAGE 'C' WITH (iscachable, isstrict);