Home > mailing lists

Re: counting distinct rows on more than one column - Mailing list pgsql-sql

From	Tom Lane
Subject	Re: counting distinct rows on more than one column
Date	March 28, 2001 15:05:45
Msg-id	18315.985795851@sss.pgh.pa.us Whole thread Raw
In response to	counting distinct rows on more than one column (Dirk Lutzebaeck <lutzeb@aeccom.com>)
List	pgsql-sql

Tree view

Dirk Lutzebaeck <lutzeb@aeccom.com> writes:
> on 7.0.3 want to COUNT
>   SELECT DISTINCT a,b FROM t;

In 7.1 you could do
select count(*) from (select distinct a,b from t) as t1;

In 7.0 and before I think you have no choice but to use a temp table.
        regards, tom lane

pgsql-sql by date:

From: Tom Lane
Date: 28 March 2001, 15:02:42
Subject: Re: DELETE FROM fails with error

From: "Douglas Brunton"
Date: 28 March 2001, 16:19:09
Subject: Oracle -> Postgresql migration

Re: counting distinct rows on more than one column - Mailing list pgsql-sql

Previous

Next