I wrote:
> Weird. I suppose I broke this in the operator-family rewrite.
> Will look.
Sigh ... I fat-fingered some loop control logic ...
Index: indxpath.c
===
RCS file: /cvsroot/pgsql/src/backend/optimizer/path/indxpath.c,v
retriev
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> 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:
Weird. I suppose I broke this in the operator-family rewrite.
Will
[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',
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. T
