Re: deleting function

pavunkumar <pavun(dot)bks(at)gmail(dot)com> 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