pl/pgsql errors

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема pl/pgsql errors
Дата
Msg-id 3E633D63.7050406@klaster.net
обсуждение исходный текст
Список pgsql-sql
Hi

create function....
declare  some_field   integer;
begin  some_field=1;  insert into some_table (some_field) values (some_field);
end;

When we try to execute such function, we get:
"ERROR:  parser: parse error at or near "$1" at character..."
Well, example above is clear enough to find, that I declared field with 
the same name as in a table. I lost a lot of time trying to find mistake 
inside long functions until I remembered, what this strange error mean.

Would it be difficult to add special ERROR for this case? It annoyed me 
so many times...

Regards,
Tomasz Myrta



В списке pgsql-sql по дате отправления: