Re: How to FindNearest - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: How to FindNearest
Date
Msg-id 20061003171125.GA5744@wolff.to
Whole thread Raw
In response to Re: How to FindNearest  ("Alexander Ilyin" <a_ilyin@ukr.net>)
List pgsql-sql
On Tue, Oct 03, 2006 at 14:43:40 +0300, Alexander Ilyin <a_ilyin@ukr.net> wrote:
> 
> Thank you for your great idea. But how it can be used for positioning the cursor in the already existed ResultSet?
Usingyour idea I can found the closest to targetvalue row but not its position in my ResultSet.
 

You wouldn't be able to use it to position a cursor. But if you aren't
retrieving a lot of records at once, this may still be a workable strategy
for you.

> Anyway thank you for your idea it is very useful by itself. Also I can solve my problem using your idea and emulating
themovement in my existed ResultSet. Even better - no need to store the large RS between cursor movements. Just each
timeI need to fetch the all visible rows.
 

That sounds pretty reasonable.


pgsql-sql by date:

Previous
From: chrisj
Date:
Subject: Re: Assigning a timestamp without timezone to a timestamp
Next
From: Bruno Wolff III
Date:
Subject: Re: Update 3 columns w/ 1 function calc 3 values?