Re: Out of memory error

On Wed, 09 Feb 2005 13:18:44 +0100, Tino Wildenhain  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
> 
>