Merlin Moncure <mmoncure@xxxxxxxxx> writes: > On Sat, Apr 3, 2010 at 3:02 PM, Scott Bailey <artacus@xxxxxxxxxxx> wrote: >> SELECT COUNT( DISTINCT row(col1, col2, col3) ) FROM foo > very clever! This is similar to how I use rowtypes to get around the > single column restrictions on function calls in the select field list. Cute, but note it will only work in 8.4 or later ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general