On Wed, Jun 2, 2010 at 1:51 PM, Plugge, Joe R. <JRPlugge@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