Re: [HACKERS] xmltable SQL conformance
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
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 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 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 >
[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: 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. -- 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