Re: deleting function - Mailing list pgsql-general

pavunkumar <pavun.bks@gmail.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