Re: How to ensure column names are double quoted while using execute format when building a stored procedure?

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Дата
Msg-id 3d76aa2d-0e1e-8cff-49de-93be10a2a5ea@aklaver.com
обсуждение исходный текст
Ответ на Re: How to ensure column names are double quoted while using execute format when building a stored procedure?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On 12/16/21 14:11, David G. Johnston wrote:
> On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
> 
>     This:
> 
>     'count of nulls in "UNIQUE_REFERENCE_NUMBER"'
> 
>     is just plain incorrect syntax.
> 
> 
> <single quote>count of nulls in <double 
> quote>UNIQUE_REFRENCE_NUMBER<double quote><single quote>
> 
> That is not invalid syntax.  It is just literal single quoted text - the 
> double quotes are simply characters in the string.

Alright I took it to be what followed:

count("""UNIQUE_REFERENCE_NUMBER""").

Now I see it is a tag for the count.

> 
> David J.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Следующее
От: Mladen Gogala
Дата:
Сообщение: Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL