From: "Ara.T.Howard" <ahoward@...>
Date: 2004-07-21T21:32:06+09:00
Subject: Re: ruby postgresql question

On Wed, 21 Jul 2004, Mark Firestone wrote:

> Does anyone know of a good way to basically seek through a large query
> record by record (like we used to do with the SEEK command in Clipper?) ...
> I am converting the Ruby BBS to use postgres.  Basically, I have real
> message numbers and the message numbers displayed by the system (so the
> messages can be 1-x) but the real message numbers (which are unique and
> assending) can be used to keep track of the last read pointer.
>
> I could make an array of message numbers, each time a user trys to pull a
> message up, but this seens wasteful.
>
> Thanks.
>
> Mark

are you asking about cursors?

-a
--
===============================================================================
| EMAIL   :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE   :: 303.497.6469
| A flower falls, even though we love it;
| and a weed grows, even though we do not love it. 
|   --Dogen
===============================================================================