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

Hi,

We have a query "select count(count(*)) from test group by
trunc(test_date)". This works fine with Oracle but when moving to postgres I
changed it to "select count(count(*)) from test group by date_trunc('day',
test_date)" but I get the following error

ERROR:  Aggregate function calls may not be nested

Can some one help me...

Thanks
Yuva