On Apr 24, 8:55 pm, [email protected] (Tom Lane) wrote:
> pavunkumar <[email protected]> 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 ([email protected])
> 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....!
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
