Re: pgsql: JSON_TABLE

2022-04-05 Thread Andrew Dunstan
On 4/5/22 15:05, Oleg Bartunov wrote: > On Tue, Apr 5, 2022 at 1:31 AM Andrew Dunstan wrote: >> >> On 4/4/22 18:16, Erik Rijkers wrote: >>> Op 04-04-2022 om 22:23 schreef Andrew Dunstan: JSON_TABLE >>> Great that this is now committed! >>> >>> I notice one changed item: the NESTED-PATH-phra

Re: pgsql: JSON_TABLE

2022-04-05 Thread Oleg Bartunov
On Tue, Apr 5, 2022 at 1:31 AM Andrew Dunstan wrote: > > > On 4/4/22 18:16, Erik Rijkers wrote: > > Op 04-04-2022 om 22:23 schreef Andrew Dunstan: > >> JSON_TABLE > > > > Great that this is now committed! > > > > I notice one changed item: the NESTED-PATH-phrase does not accept an > > alias anymor

Re: pgsql: JSON_TABLE

2022-04-05 Thread Oleg Bartunov
On Tue, Apr 5, 2022 at 1:17 AM Erik Rijkers wrote: > > Op 04-04-2022 om 22:23 schreef Andrew Dunstan: > > JSON_TABLE > > Great that this is now committed! > > I notice one changed item: the NESTED-PATH-phrase does not accept an > alias anymore. The JSON_PATH v59 patches still had: > > | NESTED PA

Re: pgsql: JSON_TABLE

2022-04-04 Thread Andrew Dunstan
On 4/4/22 18:16, Erik Rijkers wrote: > Op 04-04-2022 om 22:23 schreef Andrew Dunstan: >> JSON_TABLE > > Great that this is now committed! > > I notice one changed item: the NESTED-PATH-phrase does not accept an > alias anymore.  The JSON_PATH v59 patches still had: > > | NESTED PATH json_path_spe

Re: pgsql: JSON_TABLE

2022-04-04 Thread Erik Rijkers
Op 04-04-2022 om 22:23 schreef Andrew Dunstan: JSON_TABLE Great that this is now committed! I notice one changed item: the NESTED-PATH-phrase does not accept an alias anymore. The JSON_PATH v59 patches still had: | NESTED PATH json_path_specification [ AS path_name ] COLUMNS ( json_table