"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> 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