"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