On Wed, Jun 2, 2010 at 1:51 PM, Plugge, Joe R. <jrplu...@west.com> wrote:
> This is discussed in this Wiki:
>
>
> http://wiki.postgresql.org/wiki/Grouping_Sets
>
This would sum the results and would be incorrect. I also get this error:
select sum(page_count_count), page_count_pdate from page_count group
by rollup(page_count_pdate);
ERROR: function rollup(date) does not exist
LINE 1: ...count), page_count_pdate from page_count group by rollup(pag...
^
HINT: No function matches the given name and argument types. You
might need to add explicit type casts.
thx,
-wes
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
