function that returns dynamicly created table

Поиск
Список
Период
Сортировка
Искать
От
Michal Holečka
Тема
function that returns dynamicly created table
Дата
Msg-id
40282DF8.7020503@kmit.sk
Список
Дерево обсуждения
function that returns dynamicly created table Michal Holečka <miko@kmit.sk>
Re: function that returns dynamicly created table Josh Berkus <josh@agliodbs.com>
Re: function that returns dynamicly created table Nabil Sayegh <postgresql@e-trolley.de>
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 по дате отправления
От: Tom Ansley
Дата:
Сообщение: unsubscribe pgsql-novice
От: Josh Berkus
Дата:
FAQ