Re: BUG #3938: Row-wise comparison fails

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

cgriffo(at)practicepartner(dot)com 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