xmltable SQL conformance

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

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

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

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

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