pgsql: Common SQL/JSON clauses

2022-03-27 Thread Andrew Dunstan
Common SQL/JSON clauses This introduces some of the building blocks used by the SQL/JSON constructor and query functions. Specifically, it provides node executor and grammar support for the FORMAT JSON [ENCODING foo] clause, and values decorated with it, and for the RETURNING clause. The followin

Re: pgsql: Common SQL/JSON clauses

2022-03-23 Thread Andrew Dunstan
On 3/22/22 20:08, Tom Lane wrote: > Andrew Dunstan writes: >> On 3/22/22 18:33, Andres Freund wrote: >>> This currently triggers a number of warnings. I assume that's because of the >>> following patches not being there yet? How far out are those? >> Tomorrow, with the SQL/JSON constructors patc

Re: pgsql: Common SQL/JSON clauses

2022-03-23 Thread Alvaro Herrera
On 2022-Mar-22, Andrew Dunstan wrote: > Tomorrow, with the SQL/JSON constructors patch should resolve it. So > roughly 24 hours. It's not his fault but this happened because Alvaro > asked me to stagger the commits. Ouch, yeah. This kind of problem can be observed by using something like git re

Re: pgsql: Common SQL/JSON clauses

2022-03-22 Thread Tom Lane
Andrew Dunstan writes: > On 3/22/22 18:33, Andres Freund wrote: >> This currently triggers a number of warnings. I assume that's because of the >> following patches not being there yet? How far out are those? > Tomorrow, with the SQL/JSON constructors patch should resolve it. So > roughly 24 hour

Re: pgsql: Common SQL/JSON clauses

2022-03-22 Thread Andrew Dunstan
On 3/22/22 18:33, Andres Freund wrote: > Hi, > > On 2022-03-22 21:34:25 +, Andrew Dunstan wrote: >> Common SQL/JSON clauses >> >> This introduces some of the building blocks used by the SQL/JSON >> constructor and query functions. Specifically, it provides node >> executor and grammar support

Re: pgsql: Common SQL/JSON clauses

2022-03-22 Thread Andres Freund
Hi, On 2022-03-22 21:34:25 +, Andrew Dunstan wrote: > Common SQL/JSON clauses > > This introduces some of the building blocks used by the SQL/JSON > constructor and query functions. Specifically, it provides node > executor and grammar support for the FORMAT JSON [ENCODING foo] > clause, and

pgsql: Common SQL/JSON clauses

2022-03-22 Thread Andrew Dunstan
Common SQL/JSON clauses This introduces some of the building blocks used by the SQL/JSON constructor and query functions. Specifically, it provides node executor and grammar support for the FORMAT JSON [ENCODING foo] clause, and values decorated with it, and for the RETURNING clause. The followin