Am Mittwoch, den 09.02.2005, 10:39 -0200 schrieb Clodoaldo Pinto:
> On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain <tino@wildenhain.de> wrote:
> >
> > Will this go into the same database?
>
> Yes, this *went* into the same database.
>
> > If so, you should probably use:
> >
> > CREATE TABLE targettable AS
> > select data,
> > usuario,
> > sum(pontos) as sum_pontos,
> > sum(wus) as sum_wus
> > from usuarios
> > group by data, usuario;
> >
>
> Didn't try the create route. I have already performed the grouping. As
> the table is big, each step takes very long and i don't have more time
> to investigate further.
Well the create table ... select is the most obvious for this kind
of task. Maybe it helps next time. There are also some nice howtos
on "kind of" materialized views - which looks like you want to do
here.
Regards
Tino
