Re: refcursor

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: refcursor
Дата
Msg-id 20080901155240.GF3776@alvh.no-ip.org
обсуждение исходный текст
Ответ на refcursor  ("mike stanton" <mstanton@acsa.cl>)
Список pgsql-general
mike stanton escribió:
>
> Hello all,
> I've got a problem I can't get round. I want to declare a refcursor variable in a  C program and call a function
whichreturns a refcursor portal to the main C program. 
> When I compile the C program, I get a refcursor doesn´t exist message.
> Has anyone got a  C program which uses a refcursor variable?

Make sure the C program opens a transaction before calling the function,
otherwise the cursor is automatically closed as soon as the function ends.

--
Alvaro Herrera        Valdivia, Chile           Geotag: -39,815 -73,257
"Ah, spring... when a young penguin's fancy lightly turns to thoughts of ...
Beta testing!"                                  (Fedora 9 beta announcement)

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Oracle and Postgresql
Следующее
От: Edoardo Panfili
Дата:
Сообщение: immutable functions and enumerate type casts in indexes