Re: FETCH a cursor inside a SELECT

Поиск
Список
Период
Сортировка
От David Crawshaw
Тема Re: FETCH a cursor inside a SELECT
Дата
Msg-id 200211300009.27974.david@zentus.com
обсуждение исходный текст
Ответ на Re: FETCH a cursor inside a SELECT  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: FETCH a cursor inside a SELECT  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-general
On Sat, 30 Nov 2002 12:00 am, Shridhar Daithankar wrote:
> Not too sure but how about inserting the variable to be passed in a
> single row table and select on that table from view definition?

Now that's a hairy one! I bet it would work too, but I have multiple
users on this db. :-(

Another possibility would be removing all the logic from my function,
and using a table join in a simple 'sql' function. However I was hoping
to run more than one query a day, and being able to read my own code
has always been a plus.


Thanks anyway,

David


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: FETCH a cursor inside a SELECT
Следующее
От: Han Holl
Дата:
Сообщение: Memory leak with palloc