Re: function that returns dynamicly created table

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: function that returns dynamicly created table
Дата
Msg-id 200402091953.53867.josh@agliodbs.com
обсуждение исходный текст
Ответ на function that returns dynamicly created table  (Michal Holečka <miko@kmit.sk>)
Ответы Re: function that returns dynamicly created table  (Nabil Sayegh <postgresql@e-trolley.de>)
Список pgsql-novice
Michal,

> I would like to create function create_table(integer[]) that returns
> dynamically created table. Table is composed of  several tables which
> are left joined together. How many tables are joined is said by function
> argument - integer field..

It's possible in 7.3 and 7.4 but not in earlier versions of PostgreSQL.  See:
http://techdocs.postgresql.org/guides/SetReturningFunctions

WHY you would want to do such a thing is a question which is beyond me
entirely.

--
Josh Berkus
Aglio Database Solutions
San Francisco

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

Предыдущее
От: Michal Holečka
Дата:
Сообщение: function that returns dynamicly created table
Следующее
От: "Rajan Bhide"
Дата:
Сообщение: Performing COPY Command