contrib/xml2/pgxml.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 --SQL for XML parser
   7
   8 CREATE OR REPLACE FUNCTION xml_is_well_formed(text) RETURNS bool
   9 AS 'MODULE_PATHNAME'
  10 LANGUAGE C STRICT IMMUTABLE;
  11
  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;
  16
  17 CREATE OR REPLACE FUNCTION xml_encode_special_chars(text) RETURNS text
  18 AS 'MODULE_PATHNAME'
  19 LANGUAGE C STRICT IMMUTABLE;
  20
  21 CREATE OR REPLACE FUNCTION xpath_string(text,text) RETURNS text
  22 AS 'MODULE_PATHNAME'
  23 LANGUAGE C STRICT IMMUTABLE;
  24
  25 CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text,text) RETURNS text
  26 AS 'MODULE_PATHNAME'
  27 LANGUAGE C STRICT IMMUTABLE;
  28
  29 CREATE OR REPLACE FUNCTION xpath_number(text,text) RETURNS float4
  30 AS 'MODULE_PATHNAME'
  31 LANGUAGE C STRICT IMMUTABLE;
  32
  33 CREATE OR REPLACE FUNCTION xpath_bool(text,text) RETURNS boolean
  34 AS 'MODULE_PATHNAME'
  35 LANGUAGE C STRICT IMMUTABLE;
  36
  37 -- List function
  38
  39 CREATE OR REPLACE FUNCTION xpath_list(text,text,text) RETURNS text
  40 AS 'MODULE_PATHNAME'
  41 LANGUAGE C STRICT IMMUTABLE;
  42
  43
  44 CREATE OR REPLACE FUNCTION xpath_list(text,text) RETURNS text
  45 AS 'SELECT xpath_list($1,$2,'','')'
  46 LANGUAGE SQL STRICT IMMUTABLE;
  47
  48
  49
  50 -- Wrapper functions for nodeset where no tags needed
  51
  52
  53 CREATE OR REPLACE FUNCTION xpath_nodeset(text,text)
  54 RETURNS text
  55 AS 'SELECT xpath_nodeset($1,$2,'''','''')'
  56 LANGUAGE SQL STRICT IMMUTABLE;
  57
  58
  59 CREATE OR REPLACE FUNCTION xpath_nodeset(text,text,text)
  60 RETURNS text
  61 AS 'SELECT xpath_nodeset($1,$2,'''',$3)'
  62 LANGUAGE SQL STRICT IMMUTABLE;
  63
  64 -- Table function
  65
  66 CREATE OR REPLACE FUNCTION xpath_table(text,text,text,text,text)
  67 RETURNS setof record
  68 AS 'MODULE_PATHNAME'
  69 LANGUAGE C STRICT STABLE;
  70
  71 -- XSLT functions
  72 -- Delete from here to the end of the file if you are not compiling with
  73 -- XSLT support.
  74
  75
  76 CREATE OR REPLACE FUNCTION xslt_process(text,text,text)
  77 RETURNS text
  78 AS 'MODULE_PATHNAME'
  79 LANGUAGE C STRICT VOLATILE;
  80
  81 -- the function checks for the correct argument count
  82
  83 CREATE OR REPLACE FUNCTION xslt_process(text,text)
  84 RETURNS text
  85 AS 'MODULE_PATHNAME'
  86 LANGUAGE C STRICT IMMUTABLE;