Re: failed to execute the psql case statement which has the function call.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: failed to execute the psql case statement which has the function call.
Дата
Msg-id CAKFQuwYBRbm_jqO4APypSLiYbqY=Qcx9d4XQc97H+KJK83SPvQ@mail.gmail.com
обсуждение исходный текст
Ответ на failed to execute the psql case statement which has the function call.  (Nikhil Ingale <niks.bgm@gmail.com>)
Ответы Re: failed to execute the psql case statement which has the function call.  (sagar jadhav <sagarjdhv5@gmail.com>)
Список pgsql-admin
Дерево обсуждения


On Tuesday, April 5, 2022, Nikhil Ingale <niks.bgm@gmail.com> wrote:
Hi All,

I've a case statement where I'm calling the user defined postgres function and failed to execute the same. Because it's assuming the variable passed inside the function as a column for the table.

You cannot use variables for identifiers in raw sql.  If you need to do that you must use dynamic sql - build a string using format and execute it.

David J.
 

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: failed to execute the psql case statement which has the function call.
Следующее
От: sagar jadhav
Дата:
Сообщение: Re: failed to execute the psql case statement which has the function call.