Re: [DEPARSE] Operators on ROW() constructors read back as row comparisons

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: Henson Choi <assam258(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org, "crprashant(at)hotmail(dot)com" <crprashant(at)hotmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: [DEPARSE] Operators on ROW() constructors read back as row comparisons
Date: 2026-11-13 07:24:48
Message-ID: CAN4CZFNEGZUpMYTyjKpemtykhOOgUKh_VgTN2foEe-rtMxEUVg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

Function-like cast syntax has the same problem, even with v4:

create view v as select record(row(1, null::int)) = record(row(1,
null::int)) as r;
select r from v;
select pg_get_viewdef('v');
-- SELECT (ROW(1, NULL::integer) = ROW(1, NULL::integer)) AS r;

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Xuneng Zhou 2026-11-13 07:43:20 Re: Deadlock detector fails to activate on a hot standby replica
Previous Message Andrey Borodin 2026-11-13 07:10:39 Re: Add wait events for server logging destination writes