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

From momjian@postgresql.org (Bruce Momjian)
Subject pgsql: Add: * %Make row-wise comparisons work per SQL spec Right
Date
Msg-id 20051226051452.F00599DD73C@postgresql.org
Whole thread Raw
List 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)

pgsql-committers by date:

Previous
From: neilc@postgresql.org (Neil Conway)
Date:
Subject: pgsql: Various cosmetic code cleanup for PL/Python: - use "bool" rather
Next
From: petere@postgresql.org (Peter Eisentraut)
Date:
Subject: pgsql: Rename pg_make_encrypted_password to PQencryptPassword.