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;