select records by nearest value - Mailing list pgsql-novice

From e-letter
Subject select records by nearest value
Date
Msg-id BANLkTi=Y1p9gyMR566Y71UgH3tLrv1mU7w@mail.gmail.com
Whole thread Raw
Responses Re: select records by nearest value  (Frank Bax <fbax@sympatico.ca>)
Re: select records by nearest value  (e-letter <inpost@gmail.com>)
List pgsql-novice
Readers,

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?

Thanks in advance.

pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: More WAL archiving/backup questions
Next
From: Frank Bax
Date:
Subject: Re: select records by nearest value