> I am not sure if this could apply to your case, but maybe - unless you have
>done it before -
>
> you could look at windowing functions
Ciao Gabriele,
the problem is that the only thing the N queries have in
common is the base table; everything else is different,
because the different "gro
Ciao Leonardo,
I am not sure if this could apply to your case, but maybe - unless you
have done it before - you could look at windowing functions
(http://www.postgresql.org/docs/current/interactive/tutorial-window.html).
They require PG8.4+ though.
Cheers,
Gabriele
On Wed, 4 May 2011 11:51
On 05/04/2011 01:51 PM, Leonardo Francalanci wrote:
Hi,
I'm going to need to GROUP BY the same table
multiple times. That is, something like:
select (some aggregate functions here) from
tableA group by f1, f2
select (some other aggregate functions here) from
tableA group by f3, f4
etc
The
Hi,
I'm going to need to GROUP BY the same table
multiple times. That is, something like:
select (some aggregate functions here) from
tableA group by f1, f2
select (some other aggregate functions here) from
tableA group by f3, f4
etc
The table is pretty large; can someone suggest the
best way
