On 05/14/11 06:49, e-letter wrote:
> A database is structured as follows:
> 1 text1
> 1000 text2
> 500 text3
> where column 1 consists of integers. Is it possible to create query
> that will select the most appropriate records for a sum of integers.
> For example, if the target sum of integers is 50, is it possible to
> select a set of records that will be closest to this value?
I think your question is a variation of the "nearest neighbour" problem.
I found this page useful, even though I do not use PostGIS.
In your case the "distance" function might be as simple as
"ABS(id - 50)"
where "id" is the first column in your sample table above.
In response to
pgsql-novice by date
|Next:||From: Joshua Tolley||Date: 2011-05-14 13:44:04|
|Subject: Re: More WAL archiving/backup questions|
|Previous:||From: e-letter||Date: 2011-05-14 10:49:16|
|Subject: select records by nearest value|