Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-09 Thread Peter Baumann
Hi Stefan, On 07/09/2016 04:03 PM, Stefan Keller wrote: > Hi Peter, hi all, > > I wrote 2016-07-06 13:19 GMT+02:00: >> ... >> 2016-07-04 6:44 GMT+02:00 Thomas Munro : >>> ... But ISO/IEC CD 9075-15 >>> (Multi-Dimensional Arrays) is in stage 30.92 "CD referred back to >>> Working Group". Is that h

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-09 Thread Stefan Keller
Hi Peter, hi all, I wrote 2016-07-06 13:19 GMT+02:00: > ... > 2016-07-04 6:44 GMT+02:00 Thomas Munro : >> ... But ISO/IEC CD 9075-15 >> (Multi-Dimensional Arrays) is in stage 30.92 "CD referred back to >> Working Group". Is that how they say "returned with feedback"? >> ISO/IEC PDTR 19075-5 (Row

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-06 Thread Stefan Keller
Thomas 2016-07-04 6:44 GMT+02:00 Thomas Munro : > ... But ISO/IEC CD 9075-15 > (Multi-Dimensional Arrays) is in stage 30.92 "CD referred back to > Working Group". Is that how they say "returned with feedback"? > ISO/IEC PDTR 19075-5 (Row Pattern Recognition) has also reached stage > 30.60. Does

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-05 Thread Pavel Stehule
2016-07-06 5:17 GMT+02:00 Peter Eisentraut : > On 7/2/16 12:40 AM, Pavel Stehule wrote: > >> So ANSI SQL conform implementation of JSON support is still possible in >> Postgres. >> > > It is possible, but in this case I think it's not worth it. Our built-in > stuff is significantly simpler and mo

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-05 Thread Peter Eisentraut
On 7/2/16 12:40 AM, Pavel Stehule wrote: So ANSI SQL conform implementation of JSON support is still possible in Postgres. It is possible, but in this case I think it's not worth it. Our built-in stuff is significantly simpler and more powerful and already in widespread use. It is worth ke

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-05 Thread Peter Eisentraut
On 7/1/16 10:42 PM, Andreas Karlsson wrote: On 07/01/2016 07:31 PM, Andres Freund wrote: Yeah, but since when has the SQL standard adopted any existing implementation's spelling of a feature? It seems to be politically impossible. Especially if nobody really lobbies on part of postgresql. Ha

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-05 Thread Peter Eisentraut
On 7/4/16 12:44 AM, Thomas Munro wrote: ISO/IEC PDTR 19075-5 (Row Pattern Recognition) has also reached stage 30.60. Does anyone know what that one is about? Maybe something like MATCH_RECOGNIZE in Oracle? That's exactly what that is. -- Peter Eisentraut http://www.2ndQuadrant.c

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-03 Thread Thomas Munro
On Wed, Jun 29, 2016 at 11:51 AM, Stefan Keller wrote: > Hi, > > FYI: I'd just like to point you to following two forthcoming standard > parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on > "Multi-Dimensional Arrays" (SQL/MDA). > > They define there some things different as already

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-02 Thread Tom Lane
Andreas Karlsson writes: > Has any of the major PostgreSQL companies looked into sending members to > the ISO committee? It would be nice if we could be represented. Peter E. had observer status at one point, don't know if he still does. regards, tom lane -- Sent via

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-01 Thread Pavel Stehule
Hi 2016-07-01 20:46 GMT+02:00 Peter Eisentraut < peter.eisentr...@2ndquadrant.com>: > On 7/1/16 7:06 AM, Craig Ringer wrote: > >> Yeah, but since when has the SQL standard adopted any existing >> implementation's spelling of a feature? It seems to be politically >> impossible. >> > > The SQL/JSON

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-01 Thread Andreas Karlsson
On 07/01/2016 07:31 PM, Andres Freund wrote: Yeah, but since when has the SQL standard adopted any existing implementation's spelling of a feature? It seems to be politically impossible. Especially if nobody really lobbies on part of postgresql. Has any of the major PostgreSQL companies looke

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-01 Thread Peter Eisentraut
On 7/1/16 7:06 AM, Craig Ringer wrote: Yeah, but since when has the SQL standard adopted any existing implementation's spelling of a feature? It seems to be politically impossible. The SQL/JSON thing is pretty much straight from Oracle and Microsoft (and notably completely different from DB2).

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-01 Thread Andres Freund
On 2016-07-01 19:06:06 +0800, Craig Ringer wrote: > On 1 July 2016 at 17:52, Oleg Bartunov wrote: > > > On Wed, Jun 29, 2016 at 2:51 AM, Stefan Keller wrote: > > > Hi, > > > > > > FYI: I'd just like to point you to following two forthcoming standard > > > parts from "ISO/IEC JTS 1/SC 32" comitte

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-01 Thread Craig Ringer
On 1 July 2016 at 17:52, Oleg Bartunov wrote: > On Wed, Jun 29, 2016 at 2:51 AM, Stefan Keller wrote: > > Hi, > > > > FYI: I'd just like to point you to following two forthcoming standard > > parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on > > "Multi-Dimensional Arrays" (SQL/M

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-07-01 Thread Oleg Bartunov
On Wed, Jun 29, 2016 at 2:51 AM, Stefan Keller wrote: > Hi, > > FYI: I'd just like to point you to following two forthcoming standard > parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on > "Multi-Dimensional Arrays" (SQL/MDA). > > They define there some things different as already

Re: [HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-06-30 Thread Pavel Stehule
Hi 2016-06-29 1:51 GMT+02:00 Stefan Keller : > Hi, > > FYI: I'd just like to point you to following two forthcoming standard > parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on > "Multi-Dimensional Arrays" (SQL/MDA). > > They define there some things different as already in PG. S

[HACKERS] Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI)

2016-06-28 Thread Stefan Keller
Hi, FYI: I'd just like to point you to following two forthcoming standard parts from "ISO/IEC JTS 1/SC 32" comittee: one on JSON, and one on "Multi-Dimensional Arrays" (SQL/MDA). They define there some things different as already in PG. See also Peter Baumann's slides [1] and e.g. [2] :Stefan [