| From: | Sajeev Mayandi <Sajeev_Mayandi(at)symantec(dot)com> |
|---|---|
| To: | "pgus-general(at)postgresql(dot)org" <pgus-general(at)postgresql(dot)org> |
| Subject: | DECLARING THE CURSOR WITH HOLD |
| Date: | 2013-05-21 23:27:30 |
| Message-ID: | CDC1527B.41A53%sajeev_mayandi@symantec.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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.
Thanks,
Sajeev
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2013-05-22 00:21:54 | Re: [GENERAL] ODBC constructs |
| Previous Message | Sergey Konoplev | 2013-05-21 23:26:38 | Re: Strange locking problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-05-22 00:57:03 | Re: DECLARING THE CURSOR WITH HOLD |
| Previous Message | Sandy Joseph Padala | 2013-05-08 10:37:35 | About Instant PostgreSQL Starter book from Packt |