Re: How to FindNearest

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: How to FindNearest
Дата
Msg-id 20061003171125.GA5744@wolff.to
обсуждение исходный текст
Ответ на Re: How to FindNearest  ("Alexander Ilyin" <a_ilyin@ukr.net>)
Список 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 по дате отправления:

Предыдущее
От: chrisj
Дата:
Сообщение: Re: Assigning a timestamp without timezone to a timestamp
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Update 3 columns w/ 1 function calc 3 values?