File: xml.txt

package info (click to toggle)
highlight.js 9.18.5%2Bdfsg1-2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, trixie
  • size: 6,672 kB
  • sloc: javascript: 40,928; python: 342; makefile: 160; sh: 11
file content (47 lines) | stat: -rw-r--r-- 1,397 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
-- xml

XMLPARSE (DOCUMENT '...' PRESERVE WHITESPACE)
XMLPARSE (CONTENT '...' STRIP WHITESPACE)
XMLSERIALIZE ( DOCUMENT '...' AS text )
XMLSERIALIZE ( CONTENT '...' AS text )

SET XML OPTION DOCUMENT;
SET XML OPTION CONTENT;

SELECT xmlcomment('...');
SELECT xmlconcat('...', '...');
SELECT xmlelement(name foo, xmlattributes('...' as bar));
SELECT xmlforest('...' AS foo, 123 AS bar);
SELECT xmlpi(name php, '...');
SELECT xmlroot(xmlparse(document '...'), version '...', standalone yes);
SELECT xmlagg(x ORDER BY y DESC) FROM test;

SELECT xmlexists('...' PASSING BY REF '...');

SELECT xpath('...', '...', ARRAY[ARRAY['...', '...']]);
SELECT xpath_exists('...', '...', ARRAY[ARRAY['...', '...']]);

SELECT XMLTABLE('...' PASSING data COLUMNS id int PATH '...' DEFAULT '...', ordinality FOR ORDINALITY) ;

SELECT XMLTABLE(XMLNAMESPACES('...' AS x, '...' AS "B"), '...' PASSING (SELECT data FROM xmldata) COLUMNS foo int PATH '...');

foo IS DOCUMENT
foo IS NOT DOCUMENT

xml_is_well_formed(..)
xml_is_well_formed_document(..)
xml_is_well_formed_content(..)
table_to_xml(..)
query_to_xml(..)
cursor_to_xml(..)
table_to_xmlschema(..)
query_to_xmlschema(..)
cursor_to_xmlschema(..)
table_to_xml_and_xmlschema(..)
query_to_xml_and_xmlschema(..)
schema_to_xml(..)
schema_to_xmlschema(..)
schema_to_xml_and_xmlschema(..)
database_to_xml(..)
database_to_xmlschema(..)
database_to_xml_and_xmlschema(..)