Feedback-ID: i131946ab:Fastmail
Message-ID: <d79950fd-b3f5-783c-919a-a95de23c0c2c@enterprisedb.com>
Date: Sat, 18 Feb 2023 19:09:34 +0100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.6.1
Subject: Re: [PATCH] Add pretty-printed XML output option
Content-Language: en-US
To: Nikolay Samokhvalov <samokhvalov@gmail.com>,
 Jim Jones <jim.jones@uni-muenster.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
References: <2f5df461-dad8-6d7d-4568-08e10608a69b@uni-muenster.de>
 <62643598-b80d-90f4-8901-b85dccadf4c4@enterprisedb.com>
 <CANNMO+Kwb4_87G8qDeN+Vk1B1vX3HvgoGW+13fJ-b6rj7qbAww@mail.gmail.com>
 <beb5a47d-4684-4b2f-8647-bacb6bd60acf@uni-muenster.de>
 <CANNMO+L5X2ynyXL2RK7gTVA-pj=Z8o8FCCr6RwLfRK_LinjSbg@mail.gmail.com>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
In-Reply-To: 
 <CANNMO+L5X2ynyXL2RK7gTVA-pj=Z8o8FCCr6RwLfRK_LinjSbg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/d79950fd-b3f5-783c-919a-a95de23c0c2c%40enterprisedb.com>
Precedence: bulk

On 17.02.23 23:24, Nikolay Samokhvalov wrote:
> 
> My idea was to follow the SQL standard (part 14, SQL/XML); 
> unfortunately, there is no free version, but there are drafts at 
> http://www.wiscorp.com/SQLStandards.html 
> <http://www.wiscorp.com/SQLStandards.html>.
> 
> <XML character string serialization> ::= XMLSERIALIZE <left paren> [ 
> <document or content> ]
> 
> <XML value expression> AS <data type> [ <XML serialize bom> ] [ <XML 
> serialize version> ] [ <XML declaration option> ]
> 
> [ <XML serialize indent> ] <right paren>
> 
> <XML serialize indent> ::= [ NO ] INDENT

Good find.  It would be better to use this standard syntax.