row value constructor bug? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject row value constructor bug?
Date
Msg-id 20011010101842Q.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: row value constructor bug?
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: What about CREATE OR REPLACE FUNCTION?
Next
From: Chris Bitmead
Date:
Subject: TOAST and TEXT