Re: function that returns dynamicly created table

#1

Michal,

Quote:

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/guide...rningFunctions

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

--
Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

#2

Josh Berkus wrote:

Quote:

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/guide...rningFunctions

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: function that returns dynamicly created table

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: function that returns dynamicly created table - 02-09-2004 , 09:53 PM

Re: function that returns dynamicly created table - 02-10-2004 , 07:52 AM