On Fri, Apr 24, 2009 at 11:55:48AM -0400, Tom Lane wrote: > pavunkumar <pavun.bks@xxxxxxxxx> writes: > > create or replace function newd(id integer ) returns void as $$ > > delete from testing where id=$1; > > Don't use the same name for a parameter as you use for a table column > referenced in the function. I've found it helps to have a standard naming convention here; I only use identifiers starting with an underscore (i.e. "_") for function parameters and local variables. Column names always start with a lower case alphabetic letter. Other people will obviously have different ways of dealing with the ambiguity, but this has worked well for me so far. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general