diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2007-05-21 17:10:29 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2007-05-21 17:10:29 +0000 |
| commit | 3963574d13383b4f377ab054e47e4af20cb75e7d (patch) | |
| tree | c938be981d3511412f46d640f3f6226796cb8589 /src/test/regress/sql/xml.sql | |
| parent | 0c644d2c3d50a6a9f8b3821d1fe6b0f0753804b1 (diff) | |
| download | postgresql-3963574d13383b4f377ab054e47e4af20cb75e7d.tar.gz | |
XPath fixes:
- Function renamed to "xpath".
- Function is now strict, per discussion.
- Return empty array in case when XPath expression detects nothing
(previously, NULL was returned in such case), per discussion.
- (bugfix) Work with fragments with prologue: select xpath('/a',
'<?xml version="1.0"?><a /><b />'); // now XML datum is always wrapped
with dummy <x>...</x>, XML prologue simply goes away (if any).
- Some cleanup.
Nikolay Samokhvalov
Some code cleanup and documentation work by myself.
Diffstat (limited to 'src/test/regress/sql/xml.sql')
| -rw-r--r-- | src/test/regress/sql/xml.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/sql/xml.sql b/src/test/regress/sql/xml.sql index 1658a38036..2c9db299fd 100644 --- a/src/test/regress/sql/xml.sql +++ b/src/test/regress/sql/xml.sql @@ -147,9 +147,9 @@ SELECT table_name, view_definition FROM information_schema.views -- Text XPath expressions evaluation -SELECT xmlpath('/value', data) FROM xmltest; -SELECT xmlpath(NULL, NULL) IS NULL FROM xmltest; -SELECT xmlpath('', '<!-- error -->'); -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>'); -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']]); -SELECT xmlpath('//b', '<a>one <b>two</b> three <b>etc</b></a>'); +SELECT xpath('/value', data) FROM xmltest; +SELECT xpath(NULL, NULL) IS NULL FROM xmltest; +SELECT xpath('', '<!-- error -->'); +SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local:piece id="2" /></local:data>'); +SELECT xpath('//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', 'http://127.0.0.1']]); +SELECT xpath('//b', '<a>one <b>two</b> three <b>etc</b></a>'); |
