From: | Oleg Bartunov <obartunov(at)postgrespro(dot)ru> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Erik Rijkers <er(at)xs4all(dot)nl>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Andrew Alsup <bluesbreaker(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz> |
Subject: | Re: SQL/JSON: functions |
Date: | 2020-12-15 18:52:20 |
Message-ID: | CAF4Au4z6F--hr3hoqr32F-yoXgPpx8ukP02HgifJaG4t+shQdw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Dec 15, 2020 at 8:01 PM Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>
> On Fri, 17 Jul 2020 at 21:26, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru> wrote:
> >
> > Attached 50th version of the patches. Only the documentation was changed
> > since the previous version.
>
> I can imagine the effort required to get to v50, so I salute your efforts.
>
> The document for SQL Standard has now been published as CD
> 9075-2-Foundation (Thanks Peter).
SQL-2016 is already 4 years old and this what we are using for our development.
What is CD 9075-2-Foundation ?
>
> That gives us a clearer picture of what is being voted on and should
> allow Nikita to complete his work.
>
> I suggest we move forwards on this now, but if anyone objects to
> including this in PG14 in favour of waiting for the vote, please say
> so clearly so we can skip to PG15.
There is upcoming JSON v2. SQL Standard, which specifies JSON data type,
that mean we have to protect our users, or SQL-compliant applications will be
slow and developers will be disappointed. I discussed all these in my talk
at Postgres Build
http://www.sai.msu.su/~megera/postgres/talks/json-build-2020.pdf
Andrew Dunstan has volunteered to work with us on completing SQL/JSON standard,
but ...
I think we need SQL/JSON functions in PG14 and SQL/JSON compatibility mode for
json/jsonb.
>
> --
> Simon Riggs http://www.EnterpriseDB.com/
--
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2020-12-15 18:55:43 | Re: SQL/JSON: functions |
Previous Message | Fabrízio de Royes Mello | 2020-12-15 18:24:38 | Re: Minimal logical decoding on standbys |