Received: from photon.skillbrokers.bg ([212.124.94.158]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id e9UGhwC36525 for ; Mon, 30 Oct 2000 11:44:00 -0500 (EST) (envelope-from nmmm@nmmm.nu) Received: from niki ([212.124.94.130]) by photon.skillbrokers.bg (8.9.0/8.9.0) with SMTP id SAA18242 for ; Mon, 30 Oct 2000 18:30:36 +0200 From: "Nikolay Mijaylov" To: Subject: fetching rows Date: Mon, 30 Oct 2000 18:27:39 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1251" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Archive-Number: 200010/16 X-Sequence-Number: 16 Let say we have a select that returns 100 rows. I can fetch first 25 with simple sql: BEGIN WORK; DECLARE liahona CURSOR FOR SELECT * FROM films; FETCH [FORWARD] 25 IN liahona; CLOSE liahona; COMMIT WORK; but how I can fetch rows from 26 to 50? I mean withou fetching first 25. Or can I skip first 25? When i ask this you need to know that Im using PHP in web environment and try do this to get more performens from the script (now the script fetch all rows, then jump to needed row)