Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL/JSON: JSON_TABLE - Mailing list pgsql-hackers

From Erik Rijkers
Subject Re: SQL/JSON: JSON_TABLE
Date
Msg-id 1249711625.73196.1618241680812@webmailclassic.xs4all.nl
Whole thread Raw
In response to Re: SQL/JSON: JSON_TABLE  (Nikita Glukhov <n.gluhov@postgrespro.ru>)
Responses Re: SQL/JSON: JSON_TABLE
List pgsql-hackers
Tree view 
> On 2021.03.27. 02:12 Nikita Glukhov <n.gluhov@postgrespro.ru> wrote:
> Attached 47th version of the patches.

We're past feature freeze for 14 and alas, JSON_TABLE has not made it.

I have tested quite a bit with it and because I didn't find any trouble with functionality or speed, I wanted to at
leastmention that here once.
 

I looked at v47, these files
> [0001-SQL-JSON-functions-v47.patch]
> [0002-JSON_TABLE-v47.patch]
> [0003-JSON_TABLE-PLAN-DEFAULT-clause-v47.patch]
> [0004-JSON_TABLE-PLAN-clause-v47.patch]
> [manual_addition_fixed.patch]  # for this see [1], [2]

   (v47 doesn't apply anymore, as cfbot shows, but instances can still be built on top of 6131ffc43ff from 30 march
2021)

I hope it will fare better next round, version 15.

Thanks,

Erik Rijkers

[1] https://www.postgresql.org/message-id/69eefc5a-cabc-8dd3-c689-93da038c0d6a%40postgrespro.ru
[2] https://www.postgresql.org/message-id/19181987.22943.1617141503618%40webmailclassic.xs4all.nl


> -- 
> Nikita Glukhov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company

pgsql-hackers by date:

Previous
From: Ian Zagorskikh
Date:
Subject: Contribution to PostgreSQL - please give an advice
Next
From: Yulin PEI
Date:
Subject: Core dump happens when execute sql CREATE VIEW v1(c1) AS (SELECT ('4' COLLATE "C")::INT FROM generate_series(1, 10));