On 2009-04-24, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.
would this:
delete from testing where "id"=$1;
be safe?
