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

• Re: comparing rows at 2000-08-03 01:36:38 from Tom Lane

pgsql-hackers by date

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