Re: Using Execute with Dynamic Raise Commands

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Using Execute with Dynamic Raise Commands
Дата
Msg-id 11916.1195663424@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Using Execute with Dynamic Raise Commands  (Robert Bernabe <rbernabe@sandmansystems.com>)
Список pgsql-novice
Robert Bernabe <rbernabe@sandmansystems.com> writes:
>    I've been trying to create a debugging function that would receive a
> tablename and a list of columns and then the function would display all
> the contents of the table using the RAISE command.

There's no such thing as a "dynamic raise command" --- EXECUTE is for
executing regular SQL statements, not plpgsql things.  You hardly need
anything dynamic in your example anyway, seeing that you've built up
the string you want to display just fine.

            regards, tom lane

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

Предыдущее
От: Robert Bernabe
Дата:
Сообщение: Using Execute with Dynamic Raise Commands
Следующее
От: Pavel SRB
Дата:
Сообщение: sql file in the tutorial directory