regd count(count(*)) in group by

From: Yuva Chandolu <ychandolu(at)ebates(dot)com>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: regd count(count(*)) in group by
Date: 2002-07-26 20:03:40
Message-ID: A0F24737FCB34F489EC955D143BDD8510173E0DF@exchange-sf1.corp.ebates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-07-26 20:50:31 Re: regd count(count(*)) in group by
Previous Message Rod Taylor 2002-07-26 17:49:30 Re: Password sub-process ...