Re: [PoC] XMLCast (SQL/XML X025)

Jim Jones <jim.jones@uni-muenster.de>

From: Jim Jones <jim.jones@uni-muenster.de>

To: pgsql-hackers@lists.postgresql.org

Cc: Vik Fearing <vik@postgresfriends.org>

Date: 2024-08-15T21:02:23Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add missing deparsing of [NO] IDENT to XMLSERIALIZE()
- 984410b92326 18.0 cited

Attachments

v3-0001-Add-XMLCast-function-SQL-XML-X025.patch (text/x-patch) patch v3-0001


On 05.07.24 16:18, Jim Jones wrote:
> On 02.07.24 18:02, Jim Jones wrote:
>> It basically does the following:
>>
>> * When casting an XML value to a SQL data type, XML values containing
>> XSD literals will be converted to their equivalent SQL data type.
>> * When casting from a SQL data type to XML, the cast operand will be
>> translated to its corresponding XSD data type.
>>
> v2 attached adds missing return for NO_XML_SUPPORT control path in
> unescape_xml
>
v3 adds the missing XML passing mechanism BY VALUE and BY REF, as
described in the  XMLCast specification:

XMLCAST (<XML cast operand> AS <XML cast target> [ <XML passing
mechanism> ])

Tests and documentation were updated accordingly.

-- 
Jim