On Tue, Oct 03, 2006 at 14:43:40 +0300, Alexander Ilyin <[EMAIL PROTECTED]> wrote: > > Thank you for your great idea. But how it can be used for positioning the > cursor in the already existed ResultSet? Using your 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 the movement in my existed > ResultSet. Even better - no need to store the large RS between cursor > movements. Just each time I need to fetch the all visible rows. That sounds pretty reasonable. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org