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