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

From Michal Holečka
Subject function that returns dynamicly created table
Date
Msg-id 40282DF8.7020503@kmit.sk
Whole thread Raw
Responses Re: function that returns dynamicly created table  (Josh Berkus <josh@agliodbs.com>)
List pgsql-novice
Hi everybody

I am pretty new to postgre and dunno if something like this is possible
in PL/pgSQL

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..

example :

field[] = {1,1,1} means function should return      table1 left join
(table 2 leftjoin table 3);

field[]=  {1,0,0} means function should return     table 1;

if it is possible then pls let mi now how.....

thanx a lot
miso




pgsql-novice by date:

Previous
From: Tom Ansley
Date:
Subject: unsubscribe pgsql-novice
Next
From: Josh Berkus
Date:
Subject: Re: function that returns dynamicly created table