From: Chapman Flack <chap@anastigmatix.net>
To: Ramanarayana <raam.soft@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Markus Winand <markus.winand@winand.at>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Subject: Re: PostgreSQL vs SQL/XML Standards
Date: Fri, 1 Mar 2019 08:34:34 -0500
Message-ID: <5C7934EA.8010205@anastigmatix.net> (raw)
In-Reply-To: <CAKm4Xs57cROUiZDYp3XY7+Nc84=VQQ0J_dSFdWhoM8Ps6z4=_Q@mail.gmail.com>
References: <201901191335.kbjzsoefmkoa@alvherre.pgsql>
<5C438776.9080103@anastigmatix.net>
<7c345302-ade1-eedf-dc33-47cc40da4943@2ndquadrant.com>
<5C4B1F2F.2000106@anastigmatix.net>
<ae85fa30-5aea-ef56-6506-b8af2d3507ba@2ndquadrant.com>
<8c02f9b5-965e-ce51-2b20-e70c0d46a6a0@2ndquadrant.com>
<CAKm4Xs57cROUiZDYp3XY7+Nc84=VQQ0J_dSFdWhoM8Ps6z4=_Q@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: chap@anastigmatix.net, raam.soft@gmail.com, pavel.stehule@gmail.com, alvherre@2ndquadrant.com, markus.winand@winand.at, tgl@sss.pgh.pa.us, peter.eisentraut@2ndquadrant.com
Subject: Re: PostgreSQL vs SQL/XML Standards
In-Reply-To: <5C7934EA.8010205@anastigmatix.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox