Registering pre-existing tables
emp
CREATE TABLE xmltest (
id int,
data xml
);
INSERT INTO xmltest VALUES (1, 'one');
INSERT INTO xmltest VALUES (2, 'two');
INSERT INTO xmltest VALUES (3, '
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: YtFill!
INSERT INTO xmltest VALUES (3, ':1:1: Fatal: ERROR: invalid XML document
DETAIL: line 1: Couldn't find end of Start Tag wrong line 1
SELECT * FROM xmltest;
SELECT xmlcomment('test');
SELECT xmlcomment('-test');
SELECT xmlcomment('test-');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xmlcomment('test-');
^
-stdin-::1:1: Fatal: ERROR: invalid XML comment
SELECT xmlcomment('test-');
^
SELECT xmlcomment('--test');
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xmlcomment('--test');
^
-stdin-::1:1: Fatal: ERROR: invalid XML comment
SELECT xmlcomment('--test');
^
SELECT xmlcomment('te st');
SELECT xmlconcat(xmlcomment('hello'),
xmlelement(NAME qux, 'foo'),
xmlcomment('world'));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat(xmlcomment('hello'),
^
SELECT xmlconcat('hello', 'you');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat('hello', 'you');
^
SELECT xmlconcat(1, 2);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat(1, 2);
^
SELECT xmlconcat('bad', '
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat('bad', '
SELECT xmlconcat('', NULL, '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat('', NULL, '');
^
SELECT xmlconcat('', NULL, '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat('', NULL, '');
^
SELECT xmlconcat(NULL);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat(NULL);
^
SELECT xmlconcat(NULL, NULL);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlconcat(NULL, NULL);
^
SELECT xmlelement(name element,
xmlattributes (1 as one, 'deuce' as two),
'content');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name element,
^
SELECT xmlelement(name element,
xmlattributes ('unnamed and wrong'));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name element,
^
SELECT xmlelement(name element, xmlelement(name nested, 'stuff'));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name element, xmlelement(name nested, 'stuff'));
^
SELECT xmlelement(name employee, xmlforest(name, age, salary as pay)) FROM emp;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name employee, xmlforest(name, age, salary as pay)) FROM emp;
^
SELECT xmlelement(name duplicate, xmlattributes(1 as a, 2 as b, 3 as a));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name duplicate, xmlattributes(1 as a, 2 as b, 3 as a));
^
SELECT xmlelement(name num, 37);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name num, 37);
^
SELECT xmlelement(name foo, text 'bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, text 'bar');
^
SELECT xmlelement(name foo, xml 'bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, xml 'bar');
^
SELECT xmlelement(name foo, text 'br');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, text 'br');
^
SELECT xmlelement(name foo, xml 'br');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, xml 'br');
^
SELECT xmlelement(name foo, array[1, 2, 3]);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, array[1, 2, 3]);
^
SET xmlbinary TO base64;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: VariableSetStmt, not supported name: xmlbinary
SET xmlbinary TO base64;
^
SELECT xmlelement(name foo, bytea 'bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, bytea 'bar');
^
SET xmlbinary TO hex;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: VariableSetStmt, not supported name: xmlbinary
SET xmlbinary TO hex;
^
SELECT xmlelement(name foo, bytea 'bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, bytea 'bar');
^
SELECT xmlelement(name foo, xmlattributes(true as bar));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, xmlattributes(true as bar));
^
SELECT xmlelement(name foo, xmlattributes('2009-04-09 00:24:37'::timestamp as bar));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, xmlattributes('2009-04-09 00:24:37'::timestamp as bar));
^
SELECT xmlelement(name foo, xmlattributes('infinity'::timestamp as bar));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, xmlattributes('infinity'::timestamp as bar));
^
SELECT xmlelement(name foo, xmlattributes('<>&"''' as funny, xml 'br' as funnier));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name foo, xmlattributes('<>&"''' as funny, xml 'br' as funnier));
^
SELECT xmlparse(content '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '');
^
SELECT xmlparse(content ' ');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content ' ');
^
SELECT xmlparse(content 'abc');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content 'abc');
^
SELECT xmlparse(content 'x');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content 'x');
^
SELECT xmlparse(content '&');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '&');
^
SELECT xmlparse(content '&idontexist;');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '&idontexist;');
^
SELECT xmlparse(content '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '');
^
SELECT xmlparse(content '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '');
^
SELECT xmlparse(content '&idontexist;');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '&idontexist;');
^
SELECT xmlparse(content '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(content '');
^
SELECT xmlparse(document ' ');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document ' ');
^
SELECT xmlparse(document 'abc');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document 'abc');
^
SELECT xmlparse(document 'x');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document 'x');
^
SELECT xmlparse(document '&');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document '&');
^
SELECT xmlparse(document '&idontexist;');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document '&idontexist;');
^
SELECT xmlparse(document '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document '');
^
SELECT xmlparse(document '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document '');
^
SELECT xmlparse(document '&idontexist;');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document '&idontexist;');
^
SELECT xmlparse(document '');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlparse(document '');
^
SELECT xmlpi(name foo);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name foo);
^
SELECT xmlpi(name xml);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name xml);
^
SELECT xmlpi(name xmlstuff);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name xmlstuff);
^
SELECT xmlpi(name foo, 'bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name foo, 'bar');
^
SELECT xmlpi(name foo, 'in?>valid');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name foo, 'in?>valid');
^
SELECT xmlpi(name foo, null);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name foo, null);
^
SELECT xmlpi(name xml, null);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name xml, null);
^
SELECT xmlpi(name xmlstuff, null);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name xmlstuff, null);
^
SELECT xmlpi(name "xml-stylesheet", 'href="mystyle.css" type="text/css"');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name "xml-stylesheet", 'href="mystyle.css" type="text/css"');
^
SELECT xmlpi(name foo, ' bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name foo, ' bar');
^
SELECT xmlroot(xml '', version no value, standalone no value);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot(xml '', version no value, standalone no value);
^
SELECT xmlroot(xml '', version '2.0');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot(xml '', version '2.0');
^
SELECT xmlroot(xml '', version no value, standalone yes);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot(xml '', version no value, standalone yes);
^
SELECT xmlroot(xml '', version no value, standalone yes);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot(xml '', version no value, standalone yes);
^
SELECT xmlroot(xmlroot(xml '', version '1.0'), version '1.1', standalone no);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot(xmlroot(xml '', version '1.0'), version '1.1', standalone no);
^
SELECT xmlroot('', version no value, standalone no);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot('', version no value, standalone no);
^
SELECT xmlroot('', version no value, standalone no value);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot('', version no value, standalone no value);
^
SELECT xmlroot('', version no value);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot('', version no value);
^
SELECT xmlroot (
xmlelement (
name gazonk,
xmlattributes (
'val' AS name,
1 + 1 AS num
),
xmlelement (
NAME qux,
'foo'
)
),
version '1.0',
standalone yes
);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlroot (
^
SELECT xmlserialize(content data as character varying(20)) FROM xmltest;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 393
SELECT xmlserialize(content data as character varying(20)) FROM xmltest;
^
SELECT xmlserialize(content 'good' as char(10));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 393
SELECT xmlserialize(content 'good' as char(10));
^
SELECT xmlserialize(document 'bad' as text);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 393
SELECT xmlserialize(document 'bad' as text);
^
SELECT xml 'bar' IS DOCUMENT;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xml 'bar' IS DOCUMENT;
^
SELECT xml 'barfoo' IS DOCUMENT;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xml 'barfoo' IS DOCUMENT;
^
SELECT xml '' IS NOT DOCUMENT;
-stdin-:: Error: Parse Sql
-stdin-::1:21: Error: alternative is not implemented yet : 143
SELECT xml '' IS NOT DOCUMENT;
^
SELECT xml 'abc' IS NOT DOCUMENT;
-stdin-:: Error: Parse Sql
-stdin-::1:18: Error: alternative is not implemented yet : 143
SELECT xml 'abc' IS NOT DOCUMENT;
^
SELECT '<>' IS NOT DOCUMENT;
-stdin-:: Error: Parse Sql
-stdin-::1:13: Error: alternative is not implemented yet : 143
SELECT '<>' IS NOT DOCUMENT;
^
SELECT xmlagg(data) FROM xmltest;
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xmlagg(data) FROM xmltest;
^
-stdin-::1:1: Fatal: ERROR: invalid XML document
DETAIL: line 1: Extra content at the end of the document
onetwo
^
SELECT xmlagg(data) FROM xmltest;
^
SELECT xmlagg(data) FROM xmltest WHERE id > 10;
SELECT xmlelement(name employees, xmlagg(xmlelement(name name, name))) FROM emp;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlelement(name employees, xmlagg(xmlelement(name name, name))) FROM emp;
^
-- Check mapping SQL identifier to XML name
SELECT xmlpi(name ":::_xml_abc135.%-&_");
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
-- Check mapping SQL identifier to XML name
^
SELECT xmlpi(name "123");
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: alternative is not implemented yet : 143
SELECT xmlpi(name "123");
^
PREPARE foo (xml) AS SELECT xmlconcat('', $1);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: RawStmt: alternative is not implemented yet : 301
PREPARE foo (xml) AS SELECT xmlconcat('', $1);
^
SET XML OPTION DOCUMENT;
EXECUTE foo ('');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: RawStmt: alternative is not implemented yet : 302
EXECUTE foo ('');
^
EXECUTE foo ('bad');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: RawStmt: alternative is not implemented yet : 302
EXECUTE foo ('bad');
^
SELECT xml '';
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xml '';
^
-stdin-::1:1: Fatal: ERROR: invalid XML document
DETAIL: line 1: Extra content at the end of the document
^
SELECT xml '';
^
SET XML OPTION CONTENT;
EXECUTE foo ('');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: RawStmt: alternative is not implemented yet : 302
EXECUTE foo ('');
^
EXECUTE foo ('good');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: RawStmt: alternative is not implemented yet : 302
EXECUTE foo ('good');
^
SELECT xml ' ';
SELECT xml ' ';
SELECT xml '';
SELECT xml ' oops ';
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xml ' oops ';
^
-stdin-::1:1: Fatal: ERROR: invalid XML document
DETAIL: line 1: Start tag expected, '<' not found
oops
^
SELECT xml ' oops ';
^
SELECT xml ' ';
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xml ' ';
^
-stdin-::1:1: Fatal: ERROR: invalid XML document
DETAIL: line 1: Extra content at the end of the document
^
SELECT xml ' ';
^
SELECT xml '';
-stdin-:: Fatal: Execution
-stdin-::1:1: Fatal: Execution of node: Result
SELECT xml '';
^
-stdin-::1:1: Fatal: ERROR: invalid XML document
DETAIL: line 1: Extra content at the end of the document
^
SELECT xml '';
^
-- Test backwards parsing
CREATE VIEW xmlview1 AS SELECT xmlcomment('test');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
-- Test backwards parsing
^
CREATE VIEW xmlview2 AS SELECT xmlconcat('hello', 'you');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview2 AS SELECT xmlconcat('hello', 'you');
^
CREATE VIEW xmlview3 AS SELECT xmlelement(name element, xmlattributes (1 as ":one:", 'deuce' as two), 'content&');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview3 AS SELECT xmlelement(name element, xmlattributes (1 as ":one:", 'deuce' as two), 'content&');
^
CREATE VIEW xmlview4 AS SELECT xmlelement(name employee, xmlforest(name, age, salary as pay)) FROM emp;
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview4 AS SELECT xmlelement(name employee, xmlforest(name, age, salary as pay)) FROM emp;
^
CREATE VIEW xmlview5 AS SELECT xmlparse(content 'x');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview5 AS SELECT xmlparse(content 'x');
^
CREATE VIEW xmlview6 AS SELECT xmlpi(name foo, 'bar');
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview6 AS SELECT xmlpi(name foo, 'bar');
^
CREATE VIEW xmlview7 AS SELECT xmlroot(xml '', version no value, standalone yes);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview7 AS SELECT xmlroot(xml '', version no value, standalone yes);
^
CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview8 AS SELECT xmlserialize(content 'good' as char(10));
^
CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);
-stdin-:: Error: Parse Sql
-stdin-::1:1: Error: expected at least one target column
CREATE VIEW xmlview9 AS SELECT xmlserialize(content 'good' as text);
^
SELECT table_name, view_definition FROM information_schema.views
WHERE table_name LIKE 'xmlview%' ORDER BY 1;
-- Text XPath expressions evaluation
SELECT xpath('/value', data) FROM xmltest;
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
-- Text XPath expressions evaluation
^
-stdin-::2:8: Error: At function: PgCall
SELECT xpath('/value', data) FROM xmltest;
^
-stdin-::2:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,xml)
SELECT xpath('/value', data) FROM xmltest;
^
SELECT xpath(NULL, NULL) IS NULL FROM xmltest;
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath(NULL, NULL) IS NULL FROM xmltest;
^
-stdin-::1:26: Error: At function: ToPg, At function: Not, At function: Exists
SELECT xpath(NULL, NULL) IS NULL FROM xmltest;
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath(NULL, NULL) IS NULL FROM xmltest;
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath(NULL, NULL) IS NULL FROM xmltest;
^
SELECT xpath('', '');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('', '');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('', '');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('', '');
^
SELECT xpath('//text()', 'number one');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('//text()', 'number one');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('//text()', 'number one');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('//text()', 'number one');
^
SELECT xpath('//loc:piece/@id', 'number one', ARRAY[ARRAY['loc', 'http://127.0.0.1']]);
SELECT xpath('//loc:piece', 'number one', ARRAY[ARRAY['loc', 'http://127.0.0.1']]);
SELECT xpath('//loc:piece', 'number one', ARRAY[ARRAY['loc', 'http://127.0.0.1']]);
SELECT xpath('//b', 'one two three etc');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('//b', 'one two three etc');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('//b', 'one two three etc');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('//b', 'one two three etc');
^
SELECT xpath('//text()', '<');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('//text()', '<');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('//text()', '<');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('//text()', '<');
^
SELECT xpath('//@value', '');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('//@value', '');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('//@value', '');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('//@value', '');
^
SELECT xpath('''<>''', '');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('''<>''', '');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('''<>''', '');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('''<>''', '');
^
SELECT xpath('count(//*)', '');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('count(//*)', '');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('count(//*)', '');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('count(//*)', '');
^
SELECT xpath('count(//*)=0', '');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('count(//*)=0', '');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('count(//*)=0', '');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('count(//*)=0', '');
^
SELECT xpath('count(//*)=3', '');
-stdin-:: Error: Type annotation
-stdin-::1:1: Error: At function: RemovePrefixMembers, At function: PgSelect, At function: PgSetItem, At function: PgResultItem
SELECT xpath('count(//*)=3', '');
^
-stdin-::1:8: Error: At function: PgCall
SELECT xpath('count(//*)=3', '');
^
-stdin-::1:8: Error: Unable to find an overload for proc xpath with given argument types: (unknown,unknown)
SELECT xpath('count(//*)=3', '');
^
SELECT xpath('name(/*)', '