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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Дата
Msg-id CAKFQuwZ-5VyPiFLPVYZcH-37g513OuJvj6kHkw_skfKyW1yFQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to ensure column names are double quoted while using execute format when building a stored procedure?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to ensure column names are double quoted while using execute format when building a stored procedure?
Список pgsql-general
Дерево обсуждения
On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <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.

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: 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?