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

Предыдущее
От: Janning Vygen
Дата:
Сообщение: Re: copy help
Следующее
От: "Tambet Matiisen"
Дата:
Сообщение: Re: pl/pgsql errors