On Apr 24, 8:55 pm, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > pavunkumar <pavun....@xxxxxxxxx> 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...@xxxxxxxxxxxxxx) > 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
