function that returns dynamicly created table

Поиск
Список
Период
Сортировка
От Michal Holečka
Тема function that returns dynamicly created table
Дата
Msg-id 40282DF8.7020503@kmit.sk
обсуждение исходный текст
Ответы Re: function that returns dynamicly created table  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Ansley
Дата:
Сообщение: unsubscribe pgsql-novice
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: function that returns dynamicly created table