diff options
| author | Neil Conway <neilc@samurai.com> | 2005-01-26 08:08:04 +0000 |
|---|---|---|
| committer | Neil Conway <neilc@samurai.com> | 2005-01-26 08:08:04 +0000 |
| commit | 9ea9892c99843e1b210ae3bbd91fbb702e6dd3ac (patch) | |
| tree | 9d71af64c6ef1583fbcd7a5eab62b2fa0e071f0a | |
| parent | 6f28c7763e103d0d2184818a7cec344157060fab (diff) | |
| download | postgresql-9ea9892c99843e1b210ae3bbd91fbb702e6dd3ac.tar.gz postgresql-9ea9892c99843e1b210ae3bbd91fbb702e6dd3ac.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.in | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in index 07e6dce7e33..6adb80481ed 100644 --- a/contrib/fuzzystrmatch/fuzzystrmatch.sql.in +++ b/contrib/fuzzystrmatch/fuzzystrmatch.sql.in @@ -17,7 +17,7 @@ LANGUAGE 'C' WITH (iscachable, isstrict); CREATE FUNCTION text_soundex(text) RETURNS text AS 'MODULE_PATHNAME', 'soundex' -LANGUAGE 'C'; +LANGUAGE 'C' WITH (iscachable, isstrict); CREATE FUNCTION dmetaphone (text) RETURNS text LANGUAGE C IMMUTABLE STRICT |