Re: Casts from jsonb to other types should cope with json null - Mailing list pgsql-hackers

From Maxim Orlov
Subject Re: Casts from jsonb to other types should cope with json null
Date
Msg-id CACG=ezbQLqU9PvHrJHbOf=28sQHhTyMRy_EWF2HE4hX_aoGtSQ@mail.gmail.com
Whole thread Raw
In response to Re: Casts from jsonb to other types should cope with json null  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Casts from jsonb to other types should cope with json null
List pgsql-hackers


On Sat, 3 Aug 2024 at 23:10, Tom Lane <tgl@sss.pgh.pa.us> wrote:
It strikes me that there's also a question of whether json::text
should translate 'null' like this.  I'm inclined to think not,
since json is in some sense a domain over text, but it's certainly
debatable.
I tend to agree with you here about the semantics of such casts. But consistency and "predictability" of 
behaviour for the casts are a bit more important in my view. At least, based on my experience. So, I'm 
for 0002 patch.
 
--
Best regards,
Maxim Orlov.

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: XMLDocument (SQL/XML X030)
Next
From: Aleksander Alekseev
Date:
Subject: Re: Quadratic planning time for ordered paths over partitioned tables