pl/pgsql errors - Mailing list pgsql-sql

From Tomasz Myrta
Subject pl/pgsql errors
Date
Msg-id 3E633D63.7050406@klaster.net
Whole thread Raw
List 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 by date:

Previous
From: Janning Vygen
Date:
Subject: Re: copy help
Next
From: "Tambet Matiisen"
Date:
Subject: Re: pl/pgsql errors