| From: | Chapman Flack <chap(at)anastigmatix(dot)net> |
|---|---|
| To: | Ramanarayana <raam(dot)soft(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Markus Winand <markus(dot)winand(at)winand(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Subject: | Re: PostgreSQL vs SQL/XML Standards |
| Date: | 2019-03-01 13:34:34 |
| Message-ID: | 5C7934EA.8010205@anastigmatix.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 03/01/19 07:15, Ramanarayana wrote:
> Hi,
> I have tested bug fixes provided by all the patches. They are working
> great. I found one minor issue
>
> select * from xmltable('*' PASSING '<e>pre<!--c1--><?pi
> arg?><![CDATA[&ent1]]><n2>&deep</n2>post</e>' COLUMNS x XML PATH '/');
>
> The above query returns the xml. But there is an extra plus symbol at the
> end
>
> <e>pre<!--c1--><?pi arg?><![CDATA[&ent1]]><n2>&deep</n2>post</e>+
Hi,
Are you sure that isn't the + added by psql when displaying a value
that contains a newline?
What happens if you repeat the query but after the psql command
\a
to leave the output unaligned?
Thanks!
-Chap
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramanarayana | 2019-03-01 14:28:33 | Re: PostgreSQL vs SQL/XML Standards |
| Previous Message | Laurenz Albe | 2019-03-01 13:14:34 | Re: Add exclusive backup deprecation notes to documentation |