On Mon, Sep 29, 2008 at 4:36 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > SELECT count(distinct make), count(distinct color) from table WHERE > >criteria<;
Is this in the SQL spec? I didn't know Agg functions could do this? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
