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 по дате отправления: