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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
