Re: Proposal to use JSON for Postgres Parser format - Mailing list pgsql-hackers

From Matthias van de Meent
Subject Re: Proposal to use JSON for Postgres Parser format
Date
Msg-id CAEze2WjPPb4wQdRyPp-K9vmBbZVUaVQCDULCpaohN_i5R1fV4g@mail.gmail.com
Whole thread Raw
In response to Re: Proposal to use JSON for Postgres Parser format  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: Proposal to use JSON for Postgres Parser format  (Michel Pelletier <pelletier.michel@gmail.com>)
List pgsql-hackers
On Mon, 31 Oct 2022 at 13:46, Alexander Korotkov <aekorotkov@gmail.com> wrote:
> On Fri, Oct 28, 2022 at 4:27 PM Andrew Dunstan <andrew@dunslane.net> wrote:
>> On 2022-10-27 Th 19:38, Andres Freund wrote:
>> > Hi,
>> >
>> > On 2022-09-19 22:29:15 -0400, Tom Lane wrote:
>> >> Maybe a compromise could be found whereby we provide a conversion function
>> >> that converts whatever the catalog storage format is to some JSON
>> >> equivalent.  That would address the needs of external code that doesn't want
>> >> to write a custom parser, while not tying us directly to JSON.
>> > +1
>>
>> Agreed.
>
> +1
>
> Michel, it seems that you now have a green light to implement node to
> json function.

I think that Tom's proposal that we +1 is on a pg_node_tree to json
SQL function / cast; which is tangentially related to the "nodeToJson
/ changing the storage format of pg_node_tree to json" proposal, but
not the same.

I will add my +1 to Tom's proposal for that function/cast, but I'm not
sure on changing the storage format of pg_node_tree to json.

Kind regards,

Matthias van de Meent



pgsql-hackers by date:

Previous
From: "Drouvot, Bertrand"
Date:
Subject: Split index and table statistics into different types of stats
Next
From: ilya.v.gladyshev@gmail.com
Date:
Subject: Re: Segfault on logical replication to partitioned table with foreign children