On Fri, Nov 17, 2000 at 10:01:28AM +0100, Arnaud Vandyck wrote:
> "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?
If you use ruby's interface to postgresql you can use num_tuples to
determine how many rows are returned by the query.
Ruby is an exiting young language somewhat like python.
Johann.
--
J.H. Spies - Tel. 082 782 0336 / 023 55 11 568 "A Song for the sabbath day. It is a good thing to give thanks
untothe LORD, and to sing praises unto thy name, O most High." Psalms 92:1