On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain <tino@xxxxxxxxxxxxx> 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.
Regards, Clodoaldo Pinto
>
> HTH
> Tino
>
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
