Re: xmltable SQL conformance

2017-08-07 20:36 GMT+02:00 Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com>:

> 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 am sorry - it my bad English :( - Czechism

> > 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
>