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

Started by Bruce Momjianover 20 years ago1 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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&amp;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&amp;r2=1.241)