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

From Andres Freund
Subject Re: SQL/JSON features for v15
Date
Msg-id 20220823172718.o4p25k2bcrmsnj3a@awork3.anarazel.de
Whole thread Raw
In response to Re: SQL/JSON features for v15  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: SQL/JSON features for v15
List pgsql-hackers
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.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: SQL/JSON features for v15
Next
From: Zhihong Yu
Date:
Subject: Re: handling multiple matching constraints in DetachPartitionFinalize()