From: | Stefan Keller <sfkeller(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Baumann <p(dot)baumann(at)jacobs-university(dot)de> |
Cc: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, peter(dot)eisentraut(at)2ndquadrant(dot)com |
Subject: | Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) |
Date: | 2016-07-09 14:03:33 |
Message-ID: | CAFcOn28bmTxuGDzfn_qtTNf5Wvwg9QuW0i2nf27gFOGmg1UP-A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Peter, hi all,
I wrote 2016-07-06 13:19 GMT+02:00:
> ...
> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>:
>> ... 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 anyone know what that one is about? ...
@Peter B. Can you clarify the stage?
Regarding the differences of array functions of the ISO proposal, I
have no clue why the working group did not follow the implementation
of PostgreSQL.
@Peter B. You know PostgreSQL well. Can you explain?
:Stefan
P.S. 2016-07-02 17:11 GMT+02:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Peter E. had observer status at one point, don't know if he still does.
@Peter E.: Do you still have observer status at the ISO committee?
2016-07-06 13:19 GMT+02:00 Stefan Keller <sfkeller(at)gmail(dot)com>:
> Thomas
>
> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>:
>> ... 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 anyone know what that one is about? Maybe something like
>
> Peter surely would know: https://www.jacobs-university.de/directory/pbaumann
>
> :Stefan
>
> 2016-07-04 6:44 GMT+02:00 Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>:
>> On Wed, Jun 29, 2016 at 11:51 AM, Stefan Keller <sfkeller(at)gmail(dot)com> 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 in PG. See also
>>> Peter Baumann's slides [1] and e.g. [2]
>>>
>>> :Stefan
>>>
>>> [1] https://www.unibw.de/inf4/professors/geoinformatics/agile-2016-workshop-gis-with-nosql
>>> [2] http://jtc1sc32.org/doc/N2501-2550/32N2528-WG3-Tutorial-Opening-Plenary.pdf
>>
>> Thanks for these pointers. On the "standards under development"
>> page[1], I see that ISO/IEC PDTR 19075-6 (SQL/JSON) is at stage 30.60
>> "Close of voting/ comment period". 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 anyone know what that one is about? Maybe something like
>> MATCH_RECOGNIZE in Oracle?
>>
>> [1] http://www.iso.org/iso/home/store/catalogue_tc/catalogue_tc_browse.htm?commid=45342&development=on
>>
>> --
>> Thomas Munro
>> http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Baumann | 2016-07-09 14:28:38 | Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) |
Previous Message | Fabien COELHO | 2016-07-09 12:52:51 | Re: pgbench - allow to store select results into variables |