Re: SQL/JSON features for v15 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: SQL/JSON features for v15
Date
Msg-id CAFj8pRDyv7vsSmN8RcpugOCctM-UudV58z14pyvJz2ZtwXPCpg@mail.gmail.com
Whole thread Raw
In response to Re: SQL/JSON features for v15  (Andres Freund <andres@anarazel.de>)
Responses Re: SQL/JSON features for v15
Re: SQL/JSON features for v15
List pgsql-hackers


út 23. 8. 2022 v 19:27 odesílatel Andres Freund <andres@anarazel.de> napsal:
Hi,

On 2022-08-23 18:06:22 +0200, Pavel Stehule wrote:
> The errors that should be handled are related to json structure errors. I
> don't think so we have to handle all errors and all conversions.
>
> The JSON knows only three types - and these conversions can be written
> specially for this case - or we can write json io routines to be able to
> signal error
> without an exception.

I think that's not true unfortunately. You can specify return types, and
composite types can be populated. Which essentially requires arbitrary
coercions.

Please, can you send an example? Maybe we try to fix a feature that is not required by standard.

Regards

Pavel


 

Greetings,

Andres Freund

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: SQL/JSON features for v15
Next
From: Nathan Bossart
Date:
Subject: Re: archive modules