Compare variables of composite type with slightly different column types

From: Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Compare variables of composite type with slightly different column types
Date: 2022-05-26 11:25:52
Message-ID: 2b8a55b3-eb5d-4b77-03fb-4b60444d0937@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
Researching on join selectivity improvement I stuck into the code in
rowtypes.c:

/*
* Have two matching columns, they must be same type
*/
if (att1->atttypid != att2->atttypid)
ereport(ERROR, ...

Why, for example, isn't allowed next trivial query:

SELECT *
FROM
(SELECT ROW(1::integer, 'robert'::text)) AS s1,
(SELECT ROW(1::bigint, 'robert'::name)) AS s2
WHERE s1 = s2;

I guess, here the compatible_oper() routine can be used to find a
appropriate operator, or something like that can be invented.
I looked into the 2cd7084 and a4424c5, but don't found any rationale.

--
Regards
Andrey Lepikhov
Postgres Professional

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message osumi.takamichi@fujitsu.com 2022-05-26 13:34:33 RE: Skipping schema changes in publication
Previous Message Amit Kapila 2022-05-26 11:10:22 Re: Handle infinite recursion in logical replication setup