Re: Function that creates a custom (temporary) table AND returns a pointer to it = impossible in pg?

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: Function that creates a custom (temporary) table AND returns a pointer to it = impossible in pg?
Дата
Msg-id 20100212114635.GB25282@a-kretschmer.de
обсуждение исходный текст
Ответ на Function that creates a custom (temporary) table AND returns a pointer to it = impossible in pg?  ("Davor J." <DavorJ@live.com>)
Список pgsql-general
In response to Davor J. :
> What I want is something similar to this:
>
>
> Basically, what I want is a similar function f() that returns me a "pointer"
> to the table which I can use in some query like this: SELECT * FROM
> regclass(f()); Currently, this query only gives me one row 'tbl_temp'...,
> but not what I want: "SELECT * FROM tbl_temp;" Can this be done in Postgres?

Take a look at
http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html


--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

В списке pgsql-general по дате отправления:

Предыдущее
От: "Davor J."
Дата:
Сообщение: Re: Function that creates a custom table AND returns it = impossible in pg?
Следующее
От: Allan Kamau
Дата:
Сообщение: Weeding out unused user created database objects, could I use pg_catalog?