Re: function that returns dynamicly created table

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