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

From Arthur Zakirov
Subject Re: PostgreSQL vs SQL/XML Standards
Date
Msg-id 89664994-34c5-089b-dd28-68be2beb73c3@postgrespro.ru
Whole thread Raw
In response to Re: PostgreSQL vs SQL/XML Standards  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: PostgreSQL vs SQL/XML Standards  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Hello Pavel,

On 09.11.2018 07:07, Pavel Stehule wrote:
> I used your patch and append regress tests. I checked the result against 
> Oracle.

I checked the patch with Chap cases. The patch fixes handling of 
boolean, number types which mentioned in the wiki.

I have a few comments related to the code and the documentation. I 
attached the patch, which fixes it.

There is an example in the documentation:

SELECT xmltable.*
   FROM xmlelements, XMLTABLE('/root' PASSING data COLUMNS element text);
        element
----------------------
    Hello2a2   bbbCC

With the patch XMLTABLE returns different result now.

copy_and_safe_free_xmlchar() function should be hid by #ifdef 
USE_LIBXML, otherwise I get an error if I build the Postgres without 
--with-libxml.

There is a comment within XmlTableGetValue(). I changed it, mainly I 
used Markus patch from the related thread mentioned by Alvaro.

Please see the changes in the patch.

-- 
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company

Attachment

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Strange wording in advanced tutorial
Next
From: Laurenz Albe
Date:
Subject: Re: Remove Deprecated Exclusive Backup Mode