[EMAIL PROTECTED] wrote:
> The row-wise compare fails in the select statement below. This works in
> PostgreSQL 8.2 but fails in 8.3.
Confirmed here.
> SELECT * from test where (str1, str2, id) > ('a', '1', 0);
The error message is:
alvherre=# SELECT * from test where (str1, str2, id) > ('a', '1', 0);
ERREUR: could not find member 4(25,25) of opfamily 426
Note that if I change the order of columns, it works:
alvherre=# SELECT * from test where (id,str1, str2) > (0,'a', '1');
id | str1 | str2
----+------+------
1 | a | 1
2 | b | 2
(2 lignes)
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
