Re: deleting function

On Apr 24, 8:55 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> pavunkumar <pavun....@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
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.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....!