Re: Fixing row comparison semantics

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgresql.org
Date: 2005-12-24T09:25:34Z
Lists: pgsql-hackers
> I've gotten interested again in the issue of row comparisons, eg
> 	(a, b, c) >= (1, 2, 3)
> We've discussed this before, the most comprehensive thread being
> http://archives.postgresql.org/pgsql-performance/2004-07/msg00188.php
> but nothing's gotten done.  Unless someone's already working on this
> I think I will take it up.

Can someone explain to me how:

(a, b) < (1, 2)

is different to

a < 1 and b < 2

?

Chris