comparing rows

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: comparing rows
Date: 2000-08-03 01:09:07
Message-ID: 20000803100907T.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Can anyone explain the ERROR below? Is this a bug or a feature?
This is 7.0.2.

test=# select (1,2,3) = (1,2,3);
?column?
----------
t
(1 row)

test=# select (1,2,3) = (1,2,9);
?column?
----------
f
(1 row)

test=# select (1,2,3) = (1,2,null);
?column?
----------

(1 row)

test=# select (1,2,null) = (1,2,null);
ERROR: Unable to identify an operator '=' for types 'unknown' and 'unknown'
You will have to retype this query using an explicit cast
--
Tatsuo Ishii

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-08-03 01:36:38 Re: comparing rows
Previous Message Tom Lane 2000-08-02 20:36:20 Re: [HACKERS] random() function produces wrong range