Received: from danbo.digsys.bg (root@danbo.digsys.bg [192.92.129.10]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA05281 for ; Sun, 7 Nov 1999 05:25:16 -0500 (EST) (envelope-from genov@lorna.digsys.bg) Received: from lorna.digsys.bg (root@lorna.digsys.bg [193.68.6.15]) by danbo.digsys.bg (8.9.0/8.9.0) with ESMTP id MAA19257; Sun, 7 Nov 1999 12:25:10 +0200 (EET) Received: from lorna.digsys.bg (genov@localhost.digsys.bg [127.0.0.1]) by lorna.digsys.bg (8.9.0/8.9.0) with ESMTP id MAA25941; Sun, 7 Nov 1999 12:25:09 +0200 (EET) Message-Id: <199911071025.MAA25941@lorna.digsys.bg> X-Mailer: exmh version 2.0.2 2/24/98 To: Tom Lane cc: pgsql-sql@postgresql.org Subject: Move forward all (Was Re: How to get last 10 rows in a table on a large database?) In-reply-to: Your message of "Sat, 06 Nov 1999 13:16:58 EST." <2549.941912218@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sun, 07 Nov 1999 12:25:08 +0200 From: Stoyan Genov Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id FAA05293 > > You are unable to say: > > begin transaction; > > declare tbl_cur cursor for .... ..... > > move forward all in tbl_cur; > > fetch backward 10 in tbl_cur; > > ........... > > end transaction; > > because when you "move forward all" the result gets lost. > > Huh? It seems to work fine for me. Well, it does not seem to work for me neither on the 6.4.2 nor on the 6.5.(1|2) version. I'll try 6.5.3 as well... Any ideas why this is so? Regards, Stoyan Genov