"Merlin Moncure" <[EMAIL PROTECTED]> writes:
> Anyways, it would be nice to be able to use the sql row constructor to
> do equality/comparison...wouldn't get caught writing such silly sql
> statements :)
You mean like this?
regression=# select row(1,2,3) = row(1,2,3);
?column?
----------
t
(1 row)
regression=# select row(1,2,3) = row(1,2,4);
?column?
----------
f
(1 row)
The semantics aren't right yet for non-equality comparisons, but it
works fine for = and != ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend