Maybe refcursors ??
All what you can do with cursors is described in
http://www.postgresql.org/docs/9.3/static/plpgsql-cursors.html
Regards
Pavel
2013/5/22 Sajeev Mayandi :
> Is there a work around to declare the cursor with hold?
>
> Thanks,
>
> Sajeev
>
> On 5/22/13 10:19 AM, "Pavel Stehule"
Is there a work around to declare the cursor with hold?
Thanks,
Sajeev
On 5/22/13 10:19 AM, "Pavel Stehule" wrote:
>Hello
>
>2013/5/22 Sajeev Mayandi :
>>
>>
>> Hi,
>>
>> I am trying to declare a cursor with hold along with NO SCROLL option.
>> I
>> am getting syntax error. Just wondering if
Hello
2013/5/22 Sajeev Mayandi :
>
>
> Hi,
>
> I am trying to declare a cursor with hold along with NO SCROLL option. I
> am getting syntax error. Just wondering if CURSOR WITH HOLD option
> supported. My code snip is.
>
> DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from
> phost
Hi,
I am trying to declare a cursor with hold along with NO SCROLL option. I am
getting syntax error. Just wondering if CURSOR WITH HOLD option supported. My
code snip is.
DECLARE noncontainer NO SCROLL CURSOR WITH HOLD FOR SELECT * from phostmapping;
NOTE: The code is in plpgsql and postg
