Thread: [HACKERS] xmltable SQL conformance
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. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
2017-08-03 22:14 GMT+02:00 Peter Eisentraut <peter.eisentraut@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:
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.
Regards
Pavel
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
2017-08-03 22:54 GMT+02:00 Pavel Stehule <pavel.stehule@gmail.com>:
2017-08-03 22:14 GMT+02:00 Peter Eisentraut <peter.eisentraut@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:
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 don't understand to X304 well - related syntax is ignored in Postgres if I understand.
Pavel
RegardsPavel
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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
2017-08-07 20:36 GMT+02:00 Peter Eisentraut <peter.eisentraut@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:
>
> 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