(record = record) inconsistent with record_eq(arg1, arg2)

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: (record = record) inconsistent with record_eq(arg1, arg2)
Date: 2023-07-31 13:45:24
Message-ID: CACJufxF6T4-vOqg1eu_JGrXszTUaHUmmjzCQUcuF6W56dhS+Vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi.
pg15: https://dbfiddle.uk/3_GxPdj4
not sure if it's a bug or I misunderstood.

select row(1,null::int) = (1,1::int); -- return null
select record_eq(row(1,null::int),(1,1::int)); --return false.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2023-07-31 14:52:09 (record = record) inconsistent with record_eq(arg1, arg2)
Previous Message PG Bug reporting form 2023-07-30 16:17:50 BUG #18043: Merge fails to insert when source and target are same table and table is empty (contains no rows)