Re: concatenating setof functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: concatenating setof functions
Дата
Msg-id 9956.1176752334@sss.pgh.pa.us
обсуждение исходный текст
Ответ на concatenating setof functions  ("Frederick Ross" <madhadron@gmail.com>)
Список pgsql-general
"Frederick Ross" <madhadron@gmail.com> writes:
> But say I have a table with an integer column.  If I had a pure SQL
> function, I could call
> select twohundreds(i) from table;
> and get a properly concatenated list of the rows resulting from
> applying twohundreds to each row of table.  This is deprecated
> according to the documentation, and it doesn't work at all with
> PLPGSQL, so how should I go about doing it?

I believe you can make an end-run around the implementation restriction
by creating a SQL-language function that's a wrapper around your plpgsql
function.

            regards, tom lane

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

Предыдущее
От: "Frederick Ross"
Дата:
Сообщение: concatenating setof functions
Следующее
От: "Ketema"
Дата:
Сообщение: Dynamic DDL