Re: Out of memory error - Mailing list pgsql-general

On Mon, 07 Feb 2005 09:32:47 -0800, Joshua D. Drake
<jd@commandprompt.com> 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;