pgsql: Add: * %Make row-wise comparisons work per SQL spec Right

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add: * %Make row-wise comparisons work per SQL spec Right
Date: 2005-12-26 05:14:52
Message-ID: 20051226051452.F00599DD73C@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Add:

* %Make row-wise comparisons work per SQL spec

Right now, '(a, b) < (1, 2)' is processed as 'a < 1 and b < 2', but
the SQL standard requires it to be processed as a column-by-column
comparison, so the proper comparison is '(a < 1) OR (a = 1 AND b < 2)'.

Modified Files:
--------------
pgsql/doc:
TODO (r1.1735 -> r1.1736)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/TODO.diff?r1=1.1735&r2=1.1736)
pgsql/doc/src/FAQ:
TODO.html (r1.240 -> r1.241)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/TODO.html.diff?r1=1.240&r2=1.241)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2005-12-26 14:58:06 pgsql: Rename pg_make_encrypted_password to PQencryptPassword.
Previous Message Neil Conway 2005-12-26 04:28:48 pgsql: Various cosmetic code cleanup for PL/Python: - use "bool" rather