"Merlin Moncure" <merlin.moncure@rcsonline.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