1 /* $PostgreSQL: pgsql/contrib/xml2/pgxml.sql.in,v 1.12 2010/03/01 18:07:59 tgl Exp $ */
3 -- Adjust this setting to control where the objects get created.
4 SET search_path = public;
8 CREATE OR REPLACE FUNCTION xml_is_well_formed(text) RETURNS bool
10 LANGUAGE C STRICT IMMUTABLE;
12 -- deprecated old name for xml_is_well_formed
13 CREATE OR REPLACE FUNCTION xml_valid(text) RETURNS bool
14 AS 'MODULE_PATHNAME', 'xml_is_well_formed'
15 LANGUAGE C STRICT IMMUTABLE;
17 CREATE OR REPLACE FUNCTION xml_encode_special_chars(text) RETURNS text
19 LANGUAGE C STRICT IMMUTABLE;
21 CREATE OR REPLACE FUNCTION xpath_string(text,text) RETURNS text
23 LANGUAGE C STRICT IMMUTABLE;
25 CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text,text) RETURNS text
27 LANGUAGE C STRICT IMMUTABLE;
29 CREATE OR REPLACE FUNCTION xpath_number(text,text) RETURNS float4
31 LANGUAGE C STRICT IMMUTABLE;
33 CREATE OR REPLACE FUNCTION xpath_bool(text,text) RETURNS boolean
35 LANGUAGE C STRICT IMMUTABLE;
39 CREATE OR REPLACE FUNCTION xpath_list(text,text,text) RETURNS text
41 LANGUAGE C STRICT IMMUTABLE;
43 CREATE OR REPLACE FUNCTION xpath_list(text,text) RETURNS text
44 AS 'SELECT xpath_list($1,$2,'','')'
45 LANGUAGE SQL STRICT IMMUTABLE;
47 -- Wrapper functions for nodeset where no tags needed
49 CREATE OR REPLACE FUNCTION xpath_nodeset(text,text)
51 AS 'SELECT xpath_nodeset($1,$2,'''','''')'
52 LANGUAGE SQL STRICT IMMUTABLE;
54 CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text)
56 AS 'SELECT xpath_nodeset($1,$2,'''',$3)'
57 LANGUAGE SQL STRICT IMMUTABLE;
61 CREATE OR REPLACE FUNCTION xpath_table(text,text,text,text,text)
64 LANGUAGE C STRICT STABLE;
68 CREATE OR REPLACE FUNCTION xslt_process(text,text,text)
71 LANGUAGE C STRICT VOLATILE;
73 -- the function checks for the correct argument count
74 CREATE OR REPLACE FUNCTION xslt_process(text,text)
77 LANGUAGE C STRICT IMMUTABLE;