Re: function that returns dynamicly created table

Поиск
Список
Период
Сортировка
От Nabil Sayegh
Тема Re: function that returns dynamicly created table
Дата
Msg-id 4028E206.7000207@e-trolley.de
обсуждение исходный текст
Ответ на Re: function that returns dynamicly created table  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-novice
Josh Berkus wrote:
> 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.

Makes perfect sense to me, if he's trying to create tables based on meta data in another table.

--
  e-Trolley Sayegh & John, Nabil Sayegh
  Tel.: 0700 etrolley /// 0700 38765539
  Fax.: +49 69 8299381-8
  PGP : http://www.e-trolley.de

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

Предыдущее
От: "Rajan Bhide"
Дата:
Сообщение: Performing COPY Command
Следующее
От: "Rajan Bhide"
Дата:
Сообщение: Re: Performing COPY Command