Re: Out of memory error

On Mon, 07 Feb 2005 09:32:47 -0800, Joshua D. Drake
 wrote:
> 
> >
> > Any advice on how to avoid it?
> 
> Use a cursor.
> 
Same thing using a cursor:

declare
	rdata record;
begin
truncate table usuarios2;
for rdata in
select distinct on (data) data
from usuarios
loop
insert into usuarios2
	(
	data,
	usuario,
	pontos,
	wus
	)
select 
	data,
	usuario,
	sum(pontos),
	sum(wus)
from usuarios
where data = rdata.data
group by data, usuario
;
end loop;
return;
end;