Re: Why this does not work ??

>Hello all, why this does not work ?
>
>-----------------------------------------
>create table original(num int);
>-----------------------------------------
>create table copia(num int);
>-----------------------------------------
>insert into original(num) values (1);
>insert into original(num) values (2);
>insert into original(num) values (3);
>-----------------------------------------
>create function copiar()
> returns int as '
> declare
> ponteiro int;
> begin
> for ponteiro in select * from original order by num asc loop
> insert into copia(num) values(ponteiro);
> end loop;
> return 1;
> end;
> ' language plpgsql;
>-----------------------------------------
>-----------------------------------------
>-----------------------------------------

Try this...

create function copiar()
returns int as '
declare
ponteiro record;
begin
for ponteiro in select * from original order by num asc loop
insert into copia(num) values(ponteiro.num);
end loop;
return 1;
end;
' language plpgsql;

cheers
Jason