The following bug has been logged online:

Bug reference:      3938
Logged by:          
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.3
Operating system:   Windows XP
Description:        Row-wise comparison fails
Details: 

The row-wise compare fails in the select statement below. This works in
PostgreSQL 8.2 but fails in 8.3.

--drop TABLE test;

CREATE TABLE test
(
  id integer,
  str1 character varying(5),
  str2 character
);
CREATE INDEX test_index1 ON test (str1, str2);

insert into test (id, str1, str2) values(1, 'a', '1');
insert into test (id, str1, str2) values(2, 'b', '2');

SELECT * from test where (str1, str2, id) > ('a', '1', 0);

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to