Re: how to construct sql

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