select refcursor into a variable

Поиск
Список
Период
Сортировка
Искать
От
Madhavi
Тема
select refcursor into a variable
Дата
Msg-id
NHBBINJKLKIANIDACONLCEGFCAAA.madhavi@zoniac.com
Список
Дерево обсуждения
select refcursor into a variable "Madhavi" <madhavi@zoniac.com>
problem starting postgresql i.e postmaster suresh s <sureshatwork@yahoo.com>
Re: problem starting postgresql i.e postmaster Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>
Re: select refcursor into a variable Richard Huxton <dev@archonet.com>
Hi all,
   I'm executing dynamic queries in postgres7.2.3. Is there a way I can
execute a refcursor and then select it into a variable and then return that
variable? My query returns the sum of values. So its only one single
value...that I want to select into a variable. How do I do this. 'cos I
don't wnat to return a refcursor.

Thanx
Madhavi


В списке pgsql-general по дате отправления
От: Shridhar Daithankar
Дата:
От: Clark C. Evans
Дата:
Сообщение: Anyone working on OLAP stuff?
FAQ