Re: [HACKERS] xmltable SQL conformance

On 8/3/17 17:07, Pavel Stehule wrote:
>         I'm looking to update the SQL conformance list for the release.  I'm
>         wondering whether the new xmltable feature fully completes the
>         following
>         items:
>
>         X300    XMLTable
>         X301    XMLTable: derived column list option
>         X302    XMLTable: ordinality column option
>         X303    XMLTable: column default option
>         X304    XMLTable: passing a context item
>
>         It looks so to me, but maybe you know more.
>
>
>     I am not sure what X304 means? Other are not supported 100% .. are
>     related to unsupported XQuery lang.
>
>
> Others than x300, 301, 302, 303 are unsupported.

I think you mean supported here?  Because they quite clearly are.

> I don't understand to
> X304 well - related syntax is ignored in Postgres if I understand.

This means that you pass in the document to work on, which is supported.

Thanks for your input.  I have updated the features list accordingly.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services