Re: deleting function - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: deleting function
Date
Msg-id 49F6D3D1.9020302@iol.ie
Whole thread Raw
In response to Re: deleting function  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-general
On 28/04/2009 10:56, Jasen Betts wrote:
> would this:
>
>   delete from testing where "id"=$1;
>
> be safe?

No - you haven't really changed anything - the double-quotes just
prevent Postgres folding mixed/upper-case identifiers to lower-case.

Why not just change the name of the argument as others have suggested?

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: deleting function
Next
From: Jasen Betts
Date:
Subject: Re: Determining the names of columns in a dynamic query