From: | Klint Gore <kgore4(at)une(dot)edu(dot)au> |
---|---|
To: | Christophe <xof(at)thebuild(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Cursor |
Date: | 2008-07-29 23:51:01 |
Message-ID: | 488FACE5.5040401@une.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Christophe wrote:
> On Jul 29, 2008, at 2:35 PM, Tom Lane wrote:
> > No, he does need an OPEN.
>
> Really? I thought that PG didn't use OPEN:
>
> "The PostgreSQL server does not implement an OPEN statement for
> cursors; a cursor is considered to be open when it is declared."
>
> http://www.postgresql.org/docs/8.3/interactive/sql-declare.html
>
It's different in PL/pgSQL.
"Before a cursor can be used to retrieve rows, it must be opened. (This
is the equivalent action to the SQL command DECLARE CURSOR.)"
http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4(at)une(dot)edu(dot)au
From | Date | Subject | |
---|---|---|---|
Next Message | Christophe | 2008-07-29 23:56:47 | Re: Cursor |
Previous Message | Scott Marlowe | 2008-07-29 23:18:39 | Re: How do I set up automatic backups? |