Received: from aix6.segi.ulg.ac.be (aix6.segi.ulg.ac.be [139.165.140.20]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eAH90as31371 for ; Fri, 17 Nov 2000 04:00:36 -0500 (EST) (envelope-from arnaud@ressource-toi.org) Received: from ressource-toi.org (vbstefi30.fapse.ulg.ac.be [139.165.77.48]) by aix6.segi.ulg.ac.be (8.9.1a/8.9.0) with ESMTP id JAA14668 for ; Fri, 17 Nov 2000 09:59:02 +0100 Message-ID: <3A14F3E8.1FD2685F@ressource-toi.org> Date: Fri, 17 Nov 2000 10:01:28 +0100 From: Arnaud Vandyck Organization: Ressource-toi.Org X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17 i686) X-Accept-Language: fr-BE, fr, en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: how many rows? [was Re: fetching rows] References: <39FDC5BC.43C5AE76@propertykey.com> <00111622091407.30061@comptechnews> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/131 X-Sequence-Number: 162 "Robert B. Easter" wrote: > > > you can't do that with a cursor, but you can use they mysql-ism called a > > limit clause. for example, to fetch rows 26-50 from that query, you'd > > do: > > > > select * from films limit 25,26; > > > > or > > > > select * from files limit 25 offset 26; I did know it was possible but did not know how to do, thanks (It was not my question but I'm glad to see the solution:) and how can I know how many rows are returned by the query? -- Arnaud ( http://www.ressource-toi.org )