Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
momjian@postgresql.org (Bruce Momjian)
Date:
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)