In my understanding below row value constructors(I hope this term is
correct) exaples should return true, but PostgreSQL does not.
test=# select (1,0) > (0,0);
?column?
----------
f
(1 row)
test=# select (0,1) > (0,0);
?column?
----------
f
(1 row)
In my understanding, (a,b) > (c,d) is equal to:
a > c or (a = c and b > d)
--
Tatsuo Ishii