diff options
author | Neil Conway | 2005-07-14 07:12:27 +0000 |
---|---|---|
committer | Neil Conway | 2005-07-14 07:12:27 +0000 |
commit | 75c76e93c78bd2ac7402b877a42befd534eb354f (patch) | |
tree | 38b07bb6df09eea50477f958cfe93d63f3985b7d /contrib/xml2/pgxml.sql.in | |
parent | 52d1d2e67c7d549ab77fc7ce9750948bb3c667c5 (diff) |
Mark xml2 CREATE FUNCTIONs as IMMUTABLE, and use the "STRICT" syntax
rather than the deprecated "WITH (isStrict)" syntax. Patch from Ilia
Kantor, minor editorializing by Neil Conway.
Diffstat (limited to 'contrib/xml2/pgxml.sql.in')
-rw-r--r-- | contrib/xml2/pgxml.sql.in | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/contrib/xml2/pgxml.sql.in b/contrib/xml2/pgxml.sql.in index f9d8bd0e31a..7936b09777d 100644 --- a/contrib/xml2/pgxml.sql.in +++ b/contrib/xml2/pgxml.sql.in @@ -1,32 +1,32 @@ --SQL for XML parser CREATE OR REPLACE FUNCTION xml_valid(text) RETURNS bool - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xml_encode_special_chars(text) RETURNS text - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_string(text,text) RETURNS text - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text,text) RETURNS text - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_number(text,text) RETURNS float4 - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_bool(text,text) RETURNS boolean - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; -- List function CREATE OR REPLACE FUNCTION xpath_list(text,text,text) RETURNS text AS 'MODULE_PATHNAME' - LANGUAGE 'c' WITH (isStrict); + LANGUAGE 'c' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_list(text,text) RETURNS text -AS 'SELECT xpath_list($1,$2,'','')' language 'SQL' WITH (isStrict); +AS 'SELECT xpath_list($1,$2,'','')' language 'SQL' STRICT IMMUTABLE; @@ -34,17 +34,17 @@ AS 'SELECT xpath_list($1,$2,'','')' language 'SQL' WITH (isStrict); CREATE OR REPLACE FUNCTION xpath_nodeset(text,text) RETURNS text AS -'SELECT xpath_nodeset($1,$2,'''','''')' language 'SQL' WITH (isStrict); +'SELECT xpath_nodeset($1,$2,'''','''')' language 'SQL' STRICT IMMUTABLE; CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text) RETURNS text AS -'SELECT xpath_nodeset($1,$2,'''',$3)' language 'SQL' WITH (isStrict); +'SELECT xpath_nodeset($1,$2,'''',$3)' language 'SQL' STRICT IMMUTABLE; -- Table function CREATE OR REPLACE FUNCTION xpath_table(text,text,text,text,text) RETURNS setof record AS 'MODULE_PATHNAME' - LANGUAGE 'c' WITH (isStrict); + LANGUAGE 'c' STRICT IMMUTABLE; -- XSLT functions -- Delete from here to the end of the file if you are not compiling with @@ -52,9 +52,9 @@ CREATE OR REPLACE FUNCTION xpath_table(text,text,text,text,text) RETURNS setof r CREATE OR REPLACE FUNCTION xslt_process(text,text,text) RETURNS text - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; -- the function checks for the correct argument count CREATE OR REPLACE FUNCTION xslt_process(text,text) RETURNS text - AS 'MODULE_PATHNAME' LANGUAGE 'c' WITH (isStrict); + AS 'MODULE_PATHNAME' LANGUAGE 'c' STRICT IMMUTABLE; |