From: Alexander Ilyin <a_ilyin@ukr.net>
To: pgsql-sql@postgresql.org
Subject: How to FindNearest
Date: Sat, 30 Sep 2006 11:43:40 +0300
Message-ID: <E1GTaRg-0009G5-H9@kitty.ukr.net> (raw)
How to implement the functionality similar to the BDE/Paradox TTable.FindNearest?
Suppose we have huge table. On the screen we need to show contents of that table in the Grid and under that Grid user can input in TextBox some letters. OnChange of this TextBox we need to make current row selection in the Grid on the row with value of some column nearest to the user input in the TextBox.
How this can be implemented in PostgreSQL?
At my first sight:
I found there is CURSOR functionality which can move that cursor through the ResultSet. But we can move it just relatively phisical row number. Is there any chance to make cursor move to the row by some rule based on the row values?
All possible approaches and ideas highly appreciated. There is just one requirement - the performance, it should work as fast as possible.
Regards,
Alexander Ilyin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: a_ilyin@ukr.net
Subject: Re: How to FindNearest
In-Reply-To: <E1GTaRg-0009G5-H9@kitty.ukr.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox