| From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Michal Holečka <miko(at)kmit(dot)sk>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: function that returns dynamicly created table |
| Date: | 2004-02-10 13:52:06 |
| Message-ID: | 4028E206.7000207@e-trolley.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajan Bhide | 2004-02-10 14:15:13 | Re: Performing COPY Command |
| Previous Message | michal | 2004-02-10 07:52:07 | plpsql performance |