Re: Finding nearest numeric value

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: Poul M=?ISO-8859-1?B?+A==?=ller Hansen <freebsd(at)pbnet(dot)dk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Finding nearest numeric value
Date: 2005-08-17 13:39:20
Message-ID: BF28B648.C998%sdavis2@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/17/05 8:50 AM, "Poul Møller Hansen" <freebsd(at)pbnet(dot)dk> wrote:

> Does anyone know how to find the row with the nearest numeric value, not
> necessarily an exact match ?

To find the nearest value in number_column to some CONSTANT (where you
replace constant with a number), try:

select *,(number_column - CONSTANT)^2 as d from tablename order by d limit
1;

Does that do it for you?

Sean

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Poul Møller Hansen 2005-08-17 14:01:04 Re: Finding nearest numeric value
Previous Message Tino Wildenhain 2005-08-17 13:20:51 Re: Postgresql server "crash" after some day