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