codekingpro/portable-devtools

1/* contrib/xml2/xml2--1.1.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION xml2" to load this file. \quit5 6--SQL for XML parser7 8-- deprecated old name for xml_is_well_formed9CREATE FUNCTION xml_valid(text) RETURNS bool10AS 'xml_is_well_formed'11LANGUAGE INTERNAL STRICT STABLE PARALLEL SAFE;12 13CREATE FUNCTION xml_encode_special_chars(text) RETURNS text14AS 'MODULE_PATHNAME'15LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;16 17CREATE FUNCTION xpath_string(text,text) RETURNS text18AS 'MODULE_PATHNAME'19LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;20 21CREATE FUNCTION xpath_nodeset(text,text,text,text) RETURNS text22AS 'MODULE_PATHNAME'23LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;24 25CREATE FUNCTION xpath_number(text,text) RETURNS float426AS 'MODULE_PATHNAME'27LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;28 29CREATE FUNCTION xpath_bool(text,text) RETURNS boolean30AS 'MODULE_PATHNAME'31LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;32 33-- List function34 35CREATE FUNCTION xpath_list(text,text,text) RETURNS text36AS 'MODULE_PATHNAME'37LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;38 39CREATE FUNCTION xpath_list(text,text) RETURNS text40AS 'SELECT xpath_list($1,$2,'','')'41LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE;42 43-- Wrapper functions for nodeset where no tags needed44 45CREATE FUNCTION xpath_nodeset(text,text)46RETURNS text47AS 'SELECT xpath_nodeset($1,$2,'''','''')'48LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE;49 50CREATE FUNCTION xpath_nodeset(text,text,text)51RETURNS text52AS 'SELECT xpath_nodeset($1,$2,'''',$3)'53LANGUAGE SQL STRICT IMMUTABLE PARALLEL SAFE;54 55-- Table function56 57CREATE FUNCTION xpath_table(text,text,text,text,text)58RETURNS setof record59AS 'MODULE_PATHNAME'60LANGUAGE C STRICT STABLE PARALLEL SAFE;61 62-- XSLT functions63 64CREATE FUNCTION xslt_process(text,text,text)65RETURNS text66AS 'MODULE_PATHNAME'67LANGUAGE C STRICT VOLATILE PARALLEL SAFE;68 69-- the function checks for the correct argument count70CREATE FUNCTION xslt_process(text,text)71RETURNS text72AS 'MODULE_PATHNAME'73LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;74