From: | Sam Mason <sam(at)samason(dot)me(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: deleting function |
Date: | 2009-04-24 16:15:02 |
Message-ID: | 20090424161502.GM12225@frubble.xen.chris-lamb.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 24, 2009 at 11:55:48AM -0400, Tom Lane wrote:
> pavunkumar <pavun(dot)bks(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Jones | 2009-04-24 16:31:41 | Re: OperationalError: FATAL: could not open file <filename>: Too many open files in system |
Previous Message | Merlin Moncure | 2009-04-24 15:56:45 | Re: feature suggestion and return to pgsql-general :-) |