Why this does not work ??
От | Roberto Rezende de Assis |
---|---|
Тема | Why this does not work ?? |
Дата | |
Msg-id | 40E6F96C.8000307@yahoo.com.br обсуждение исходный текст |
Ответы |
Re: Why this does not work ??
Re: Why this does not work ?? |
Список | pgsql-novice |
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; ----------------------------------------- ----------------------------------------- ----------------------------------------- This are the results teste=# \i for.sql CREATE TABLE CREATE TABLE INSERT 127676 1 INSERT 127677 1 INSERT 127678 1 CREATE FUNCTION teste=# select copiar(); WARNING: plpgsql: ERROR during compile of copiar near line 4 ERROR: missing .. at end of SQL expression teste=#
В списке pgsql-novice по дате отправления: