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

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема How to ensure column names are double quoted while using execute format when building a stored procedure?
Дата
Msg-id CA+i5JwYMbWKoJcP-o4HOY-G1YegxGs2FE0bWDanEF5g2WRj5yQ@mail.gmail.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
Дерево обсуждения
The following command runs but does not produce results as expected.
 
Execute Format('insert into stats select %L as id, %2$L as checks, count(%3$s) from %4$s where %5$s is null', i, 'count of nulls in '||col, col, t_name, col);

There should be a lot of nulls in columns, but it produces o count.

All columns have got capital letters in.  How to ensure that the columns are double-quote when they are fed in as variables.

Regards,

David

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

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