1/* contrib/xml2/xml2--1.1.sql */ 2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION 4\echo Use "CREATE EXTENSION xml2" to load this file. \quit 5 6--SQL for XML parser 7 8-- deprecated old name for xml_is_well_formed 9CREATE FUNCTION xml_valid(text) RETURNS bool 10AS 'xml_is_well_formed' 11LANGUAGE INTERNAL STRICT STABLE PARALLEL SAFE; 12 13CREATE FUNCTION xml_encode_special_chars(text) RETURNS text 14AS 'MODULE_PATHNAME' 15LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 16 17CREATE FUNCTION xpath_string(text,text) RETURNS text 18AS 'MODULE_PATHNAME' 19LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 20 21CREATE FUNCTION xpath_nodeset(text,text,text,text) RETURNS text 22AS 'MODULE_PATHNAME' 23LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 24 25CREATE FUNCTION xpath_number(text,text) RETURNS float4 26AS 'MODULE_PATHNAME' 27LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 28 29CREATE FUNCTION xpath_bool(text,text) RETURNS boolean 30AS 'MODULE_PATHNAME' 31LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 32 33-- List function 34 35CREATE FUNCTION xpath_list(text,text,text) RETURNS text 36AS 'MODULE_PATHNAME' 37LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 38 39CREATE FUNCTION xpath_list(text,text) RETURNS text 40AS 'SELECT xpath_list($1,$2,'','')' 41LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE; 42 43-- Wrapper functions for nodeset where no tags needed 44 45CREATE FUNCTION xpath_nodeset(text,text) 46RETURNS text 47AS 'SELECT xpath_nodeset($1,$2,'''','''')' 48LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE; 49 50CREATE FUNCTION xpath_nodeset(text,text,text) 51RETURNS text 52AS 'SELECT xpath_nodeset($1,$2,'''',$3)' 53LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE; 54 55-- Table function 56 57CREATE FUNCTION xpath_table(text,text,text,text,text) 58RETURNS setof record 59AS 'MODULE_PATHNAME' 60LANGUAGE C STRICT STABLE PARALLEL SAFE; 61 62-- XSLT functions 63 64CREATE FUNCTION xslt_process(text,text,text) 65RETURNS text 66AS 'MODULE_PATHNAME' 67LANGUAGE C STRICT VOLATILE PARALLEL SAFE; 68 69-- the function checks for the correct argument count 70CREATE FUNCTION xslt_process(text,text) 71RETURNS text 72AS 'MODULE_PATHNAME' 73LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE; 74