Re: Fixing row comparison semantics

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> Can someone explain to me how:
> (a, b) < (1, 2)
> is different to
> a < 1 and b < 2

Right at the moment our code interprets it that way, but this behavior
is wrong per spec.  It should be an ordered column-by-column comparison,
so that the equivalent simple expression is

	(a < 1) OR (a = 1 AND b < 2)

			regards, tom lane