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