pavunkumar <pavun.bks@xxxxxxxxx> writes:
> create or replace function newd(id integer ) returns void as $$
^^
> begin
> delete from testing where id=$1;
^^
> end;
> $$
> language 'plpgsql';
Don't use the same name for a parameter as you use for a table column
referenced in the function. The above is equivalent to
"delete... where $1=$1", ie, delete everything.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
