Re: regd count(count(*)) in group by - Mailing list pgsql-hackers

On 26 Jul 2002, Rod Taylor wrote:

> Try this:
>
> SELECT count(*)
>   FROM (
>     SELECT count(*)
>     FROM test
>     GROUP BY date_trunc('day', test_date)
>     ) as qry;

Or this:
SELECT COUNT(*)FROM (    SELECT DISTINCT(date_trunc('day', test_date))    FROM test);

Matthew.