| From: | Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | DECLARING THE CURSOR WITH HOLD |
| Date: | 2013-05-22 17:14:44 |
| Message-ID: | CDC24C66.41DD9%sajeev_mayandi@symantec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg배트맨 토토SQL Postg토토 커뮤니티SQL |
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 postgresql version is 9.2.
Thanks,
Sajeev
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2013-05-22 17:19:07 | Re: DECLARING THE CURSOR WITH HOLD |
| Previous Message | Alvaro Herrera | 2013-05-22 16:58:13 | Re: VACUUM FULL freezes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2013-05-22 17:19:07 | Re: DECLARING THE CURSOR WITH HOLD |
| Previous Message | Adrian Klaver | 2013-05-22 00:57:03 | Re: DECLARING THE CURSOR WITH HOLD |