Re: regd count(count(*)) in group by
От | Rod Taylor |
---|---|
Тема | Re: regd count(count(*)) in group by |
Дата | |
Msg-id | 1027716633.307.57.camel@jester обсуждение исходный текст |
Ответ на | regd count(count(*)) in group by (Yuva Chandolu <ychandolu@ebates.com>) |
Ответы |
Re: regd count(count(*)) in group by
|
Список | pgsql-hackers |
Try this: SELECT count(*) FROM (SELECT count(*)FROM testGROUP BY date_trunc('day', test_date)) as qry; On Fri, 2002-07-26 at 16:03, Yuva Chandolu wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >
В списке pgsql-hackers по дате отправления: