Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 0C8C59F965C
	for <pgsql-hackers-postgresql.org@postgresql.org>;
	Tue,  4 Sep 2007 10:38:56 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 36128-10 for
	<pgsql-hackers-postgresql.org@postgresql.org>;
	Tue,  4 Sep 2007 10:38:53 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by postgresql.org (Postfix) with ESMTP id 39E009F95C0
	for <pgsql-hackers@postgresql.org>;
	Tue,  4 Sep 2007 10:38:53 -0300 (ADT)
Received: from Courts-MTA by gwmta.wicourts.gov
	with Novell_GroupWise; Tue, 04 Sep 2007 08:38:51 -0500
Message-Id: <46DD1998.EE98.0025.0@wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Tue, 04 Sep 2007 08:38:48 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Heikki Linnakangas" <heikki@enterprisedb.com>,
	"FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>
Cc: "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Subject: Re: Updatable cursor doubt
References: <46DCB86F.9070102@fast.fujitsu.com.au>
	<46DD226F.7060602@enterprisedb.com>
In-Reply-To: <46DD226F.7060602@enterprisedb.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/130
X-Sequence-Number: 107282

>>> On Tue, Sep 4, 2007 at  4:16 AM, in message
<46DD226F.7060602@enterprisedb.com>, "Heikki Linnakangas"
<heikki@enterprisedb.com> wrote:=20
>=20
> FOR READ ONLY is actually part of the SELECT syntax.
=20
         13.1  <declare cursor>

         Function

         Define a cursor.

         Format

         <declare cursor> ::=3D
              DECLARE <cursor name> [ INSENSITIVE ] [ SCROLL ] CURSOR
                FOR <cursor specification>

         <cursor specification> ::=3D
              <query expression> [ <order by clause> ]
                [ <updatability clause> ]

         <updatability clause> ::=3D
              FOR { READ ONLY | UPDATE [ OF <column name list> ] }