Re: Casts from jsonb to other types should cope with json null

From: Maxim Orlov <orlovmg(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Maciek Sakrejda <maciek(at)pganalyze(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Casts from jsonb to other types should cope with json null
Date: 2025-01-27 13:58:05
Message-ID: CACG=eza_VY5DyrtJb44QLDr_-omaxXPd+_hBxT6O0QVYXhtLTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 24 Jan 2025 at 22:20, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>
> What I am realizing is that "JSON null becomes SQL NULL" is a rule
> that is adapted to use-case #2 but not so much to use-case #1.
>
OK, I think I've got it.

> So here's the patch, just because I promised it, but I'm now
> thinking about withdrawing it.
>
Thanks for explanation, at your will.

--
Best regards,
Maxim Orlov.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nazir Bilal Yavuz 2025-01-27 13:59:34 Re: Show WAL write and fsync stats in pg_stat_io
Previous Message Tender Wang 2025-01-27 13:40:15 Re: Adjust tuples estimate for appendrels