X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 258A2D1C516 for ; Fri, 8 Aug 2003 08:02:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 94900-06 for ; Fri, 8 Aug 2003 05:00:56 -0300 (ADT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id 4A388D1C4CA for ; Fri, 8 Aug 2003 05:02:10 -0300 (ADT) Received: from webdb (dsl-213-023-154-215.arcor-ip.net [213.23.154.215]) by web11.manitu.net (8.10.2/8.10.2) with ESMTP id h7881dE07898; Fri, 8 Aug 2003 10:01:39 +0200 Subject: Re: Using Cursors in PHP From: Markus Bertheau To: "scott.marlowe" Cc: Andreas Schmitz , pgsql-php@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-SA/wsgPOaBxZd54wAnFm" Message-Id: <1060329700.4453.0.camel@severn> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.3 (1.4.3-3) Date: 08 Aug 2003 10:01:40 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/25 X-Sequence-Number: 2202 --=-SA/wsgPOaBxZd54wAnFm Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =D0=92 =D0=A1=D1=80=D0=B4, 06.08.2003, =D0=B2 17:51, scott.marlowe =D0=BF= =D0=B8=D1=88=D0=B5=D1=82: > On Wed, 6 Aug 2003, Andreas Schmitz wrote: >=20 > >=20 > > Hello *, > >=20 > > I am just wondering if it is possible to use cursors within PHP. I need= to=20 > > page query result from a big table and I am looking for a solution to a= void=20 > > scanning the complete table using limit and offset. >=20 > Yes, you can use cursors, no you can't expect them to survive from one=20 > page to the next. What about the new feature in cursors "WITH HOLD"? Don't they survive? --=20 Markus Bertheau --=-SA/wsgPOaBxZd54wAnFm Content-Type: application/pgp-signature; name=signature.asc Content-Description: =?koi8-r?Q?=FC=D4=C1?= =?koi8-r?Q?_=DE=C1=D3=D4=D8?= =?koi8-r?Q?_=D3=CF=CF=C2=DD=C5=CE=C9=D1?= =?koi8-r?Q?_=D0=CF=C4=D0=C9=D3=C1=CE=C1?= =?koi8-r?Q?_=C3=C9=C6=D2=CF=D7=CF=CA?= =?koi8-r?Q?_=D0=CF=C4=D0=C9=D3=D8=C0?= -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQA/M1jkZ+yN9zLmHSMRAj0cAJ4xhJbi/WDGA2D55srv3Oy69H/PzwCeNfdo egG0RqegyAp3YoOBXij1c6o= =RliO -----END PGP SIGNATURE----- --=-SA/wsgPOaBxZd54wAnFm--