Re: deleting function

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: deleting function
Дата
Msg-id 49F6D3D1.9020302@iol.ie
обсуждение исходный текст
Ответ на Re: deleting function  (Jasen Betts <jasen@xnet.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: deleting function
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Determining the names of columns in a dynamic query