Re: PostgreSQL vs SQL/XML Standards - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: PostgreSQL vs SQL/XML Standards
Date
Msg-id 5C7934EA.8010205@anastigmatix.net
Whole thread Raw
In response to Re: House style for DocBook documentation?  (Ramanarayana <raam.soft@gmail.com>)
Responses Re: PostgreSQL vs SQL/XML Standards
List 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


pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Add exclusive backup deprecation notes to documentation
Next
From: Ramanarayana
Date:
Subject: Re: PostgreSQL vs SQL/XML Standards