diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-03-22 20:14:58 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-03-22 20:14:58 +0000 |
| commit | e651bcf3f623265fc0cea9d8ade6937ce89b73eb (patch) | |
| tree | 492c933e0ed6fc2f1c1f5a937d0f6940f897256e /src/test/regress/expected/xml_1.out | |
| parent | 4f896dac17f7015b34347e278fc3db4047b86e43 (diff) | |
| download | postgresql-e651bcf3f623265fc0cea9d8ade6937ce89b73eb.tar.gz | |
Add xmlpath() to evaluate XPath expressions, with namespaces support.
Nikolay Samokhvalov
Diffstat (limited to 'src/test/regress/expected/xml_1.out')
| -rw-r--r-- | src/test/regress/expected/xml_1.out | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/src/test/regress/expected/xml_1.out b/src/test/regress/expected/xml_1.out index 95b9d73615..3ba6e58d2d 100644 --- a/src/test/regress/expected/xml_1.out +++ b/src/test/regress/expected/xml_1.out @@ -197,3 +197,18 @@ SELECT table_name, view_definition FROM information_schema.views xmlview5 | SELECT XMLPARSE(CONTENT '<abc>x</abc>'::text STRIP WHITESPACE) AS "xmlparse"; (2 rows) +-- Text XPath expressions evaluation +SELECT xmlpath('/value', data) FROM xmltest; + xmlpath +--------- +(0 rows) + +SELECT xmlpath(NULL, NULL) IS NULL FROM xmltest; +ERROR: no XML support in this installation +CONTEXT: SQL function "xmlpath" statement 1 +SELECT xmlpath('', '<!-- error -->'); +ERROR: no XML support in this installation +SELECT xmlpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local:piece id="2" /></local:data>'); +ERROR: no XML support in this installation +SELECT xmlpath('//loc:piece/@id', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local:piece id="2" /></local:data>', ARRAY[ARRAY['loc'], ARRAY['http://127.0.0.1']]); +ERROR: no XML support in this installation |