From: | Robert Greig <robert(dot)j(dot)greig(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #18583: jsonb_populate_record return values cannot be queried correctly in subselects |
Date: | 2024-08-16 19:52:59 |
Message-ID: | CAGFZ9_9TmyPOfxCnbgzxwJ=o291L3iD=7_6o8iHNvDUwMtYTJA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi David,
Thank you for explaining this - I had not even considered that the
behaviour mandated by the SQL standard would be so unintuitive. At least I
now know how to achieve what I want!
Robert
On Thu, 15 Aug 2024 at 19:30, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Wednesday, August 14, 2024, PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 18583
>> Logged by: Robert Greig
>> Email address: robert(dot)j(dot)greig(at)gmail(dot)com
>> PostgreSQL version: 16.4
>> Operating system: Windows
>> Description:
>>
>> create type test_simple_type as (
>> f1 varchar(20),
>> f2 int
>> );
>>
>> where val is not null;
>>
>> It is not obvious to me why it is not working but I believe this is a
>> defect
>> and I can't find a workaround.
>>
>
> The “workaround” is to write that test: not (val is null)
>
> The meaning of is not null for a composite is non-intuitive and usually
> not what you want - i.e., true only if all fields are also non-null.
>
> The docs do cover this, and there is a pending patch to further expand on
> how null values are handled in various places in PostgreSQL.
>
> David J.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jacob Champion | 2024-08-16 23:00:26 | Re: TLS session tickets disabled? |
Previous Message | Alvaro Herrera | 2024-08-16 17:54:31 | Re: REINDEX INDEX pg_catalog.pg_default_acl_role_nsp_obj_index stuck waiting for transaction from the future in PG 13.16 |