Re: function that returns dynamicly created table - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: function that returns dynamicly created table
Date
Msg-id 4028E206.7000207@e-trolley.de
Whole thread Raw
In response to Re: function that returns dynamicly created table  (Josh Berkus <josh@agliodbs.com>)
List 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 by date:

Previous
From: "Rajan Bhide"
Date:
Subject: Performing COPY Command
Next
From: "Rajan Bhide"
Date:
Subject: Re: Performing COPY Command