Re: deleting function

On Fri, Apr 24, 2009 at 11:55:48AM -0400, Tom Lane wrote:
> pavunkumar <pavun.bks@gmail.com> 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/