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