Re: deleting function

On Apr 24, 8:55 pm, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> pavunkumar <pavun(dot)(dot)(dot)(dot)(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
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Dear Friend

Whatever your saying right , But why the function
not saying error.... ?
that is my doubt... this is what I want to
clarify....!