Re: [HACKERS] xmltable SQL conformance

2017-08-07 Thread Pavel Stehule
2017-08-07 20:36 GMT+02:00 Peter Eisentraut <
peter.eisentr...@2ndquadrant.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:
> >
> > X300XMLTable
> > X301XMLTable: derived column list option
> > X302XMLTable: ordinality column option
> > X303XMLTable: column default option
> > X304XMLTable: 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
>


Re: [HACKERS] xmltable SQL conformance

2017-08-07 Thread Peter Eisentraut
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:
> 
> X300XMLTable
> X301XMLTable: derived column list option
> X302XMLTable: ordinality column option
> X303XMLTable: column default option
> X304XMLTable: 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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


Re: [HACKERS] xmltable SQL conformance

2017-08-03 Thread Pavel Stehule
2017-08-03 22:54 GMT+02:00 Pavel Stehule :

>
>
> 2017-08-03 22:14 GMT+02:00 Peter Eisentraut  com>:
>
>> 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:
>>
>> X300XMLTable
>> X301XMLTable: derived column list option
>> X302XMLTable: ordinality column option
>> X303XMLTable: column default option
>> X304XMLTable: 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 don't understand to X304
well - related syntax is ignored in Postgres if I understand.

Pavel


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


Re: [HACKERS] xmltable SQL conformance

2017-08-03 Thread Pavel Stehule
2017-08-03 22:14 GMT+02:00 Peter Eisentraut <
peter.eisentr...@2ndquadrant.com>:

> 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:
>
> X300XMLTable
> X301XMLTable: derived column list option
> X302XMLTable: ordinality column option
> X303XMLTable: column default option
> X304XMLTable: 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.

Regards

Pavel




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