Re: SQL/JSON: functions

Zhihong Yu <zyu@yugabyte.com>

From: Zhihong Yu <zyu@yugabyte.com>

To: Andrew Dunstan <andrew@dunslane.net>

Cc: Nikita Glukhov <n.gluhov@postgrespro.ru>, Ibrar Ahmed <ibrar.ahmad@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>, Michael Paquier <michael@paquier.xyz>, Andrew Dunstan <andrew.dunstan@2ndquadrant.com>, Justin Pryzby <pryzby@telsasoft.com>, Pavel Stehule <pavel.stehule@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, Thomas Munro <thomas.munro@gmail.com>, Andrew Alsup <bluesbreaker@gmail.com>, Andres Freund <andres@anarazel.de>, Dmitry Dolgov <9erthalion6@gmail.com>, Oleg Bartunov <obartunov@postgrespro.ru>, Erik Rijkers <er@xs4all.nl>, Simon Riggs <simon@2ndquadrant.com>

Date: 2021-05-08T23:54:02Z

Lists: pgsql-hackers

On Sat, May 8, 2021 at 11:21 AM Andrew Dunstan <andrew@dunslane.net> wrote:

>
> On 4/28/21 5:55 PM, Andrew Dunstan wrote:
> >
> >
> > On Fri, Mar 26, 2021 at 9:14 PM Nikita Glukhov
> > <n.gluhov@postgrespro.ru <mailto:n.gluhov@postgrespro.ru>> wrote:
> >
> >     Attached 54th version of the patches rebased onto current master.
> >
> >     On 27.03.2021 01:30, Andrew Dunstan wrote:
> >>     Specifically, patch 4 (SQL-JSON-query-functions) fails with this
> when
> >>     built with LLVM:
> >>
> >>
> >>     There is also a bug that results in a warning in gram.y, but fixing
> it
> >>     doesn't affect this issue. Nikita, please look into this ASAP.
> >
> >     LLVM issues and gram.y are fixed.
> >
> >
> >
> >
> > It's apparently bitrotted again. See
> > <http://cfbot.cputube.org/patch_33_2901.log
> > <http://cfbot.cputube.org/patch_33_2901.log>>
> >
> >
>
>
> This set should remove the bitrot.
>
>
> cheers
>
>
> andrew
>
>
>
>
>
> --
> Andrew Dunstan
> EDB: https://www.enterprisedb.com
>
> Hi,
For 0005-SQL-JSON-functions-for-json-type-v55.patch:

+      Alternatively, you can construct <acronym>JSON</acronym> values
simply
+      using <productname>PostgreSQL</productname>-specific casts to
+      <type>json</type> and <type>jsonb</type> types.

I think the 'and' in the 3rd line should be 'or'.

+     <title>Examples</title>
+     <para>
+      Construct a JSON the provided strings:

A word seems to be missing between JSON and the.

Cheers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

JSON_TABLE: Add support for NESTED paths and columns
- bb766cde63b4 17.0 landed
Add basic JSON_TABLE() functionality
- de3600452b61 17.0 landed
Add SQL/JSON query functions
- 6185c9737cf4 17.0 landed
Add soft error handling to some expression nodes
- aaaf9449ec6b 17.0 landed
Adjust populate_record_field() to handle errors softly
- 1edb3b491bee 17.0 landed
Refactor code used by jsonpath executor to fetch variables
- faa2b953ba3b 17.0 landed
Add more SQL/JSON constructor functions
- 03734a7fed7d 17.0 landed
SQL/JSON: support the IS JSON predicate
- 6ee30209a6f1 16.0 landed
SQL/JSON: add standard JSON constructor functions
- 7081ac46ace8 16.0 landed
Improve readability of SQL/JSON documentation.
- b46bcf7a4b6f 15.0 landed
Documentation for SQL/JSON features
- a6baa4baddd5 15.0 landed
RETURNING clause for JSON() and JSON_SCALAR()
- 49082c2cc3d8 15.0 landed
SQL JSON functions
- 606948b058dc 15.0 landed
SQL/JSON query functions
- 1a36bc9dba8e 15.0 landed
IS JSON predicate
- 33a377608fc2 15.0 landed
SQL/JSON constructors
- f4fb45d15c59 15.0 landed
Common SQL/JSON clauses
- f79b803dcc98 15.0 landed
- 865fe4d5df56 15.0 landed
Doc: remove obsolete entries in table of BRIN strategy numbers.
- 0ce4cd04da55 14.0 cited
Doc: standardize markup a bit more.
- 47046763c3ed 13.0 cited
Make pg_regress.c unset PGDATABASE during make installcheck.
- 5ee96b3e2221 13.0 cited
Fix handling of GENERATED columns in CREATE TABLE LIKE INCLUDING DEFAULTS.
- b81a9c2fc525 13.0 cited