Re: Most specific match using between - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Most specific match using between
Date
Msg-id 1114099882.13303.30.camel@state.g2switchworks.com
Whole thread Raw
In response to Most specific match using between  (mmiranda@americatel.com.sv)
List pgsql-general
On Thu, 2005-04-21 at 10:51, mmiranda@americatel.com.sv wrote:
> Hi people, is there a swtich or something to instruct a between statement
> hat it must perform a most specific match ?
> These are the details, i have these table
>
>  name        | start        | end
> ---------------+---------------+-----------------
> general     | 2660000  | 2669999
> specific     | 2660124  | 2660124
> (2 rows)
>
>
> unsing the query:  select name where '2660124' between start and end
>
> i got:
>
>
> name
> ---------
> general
> specific
>
>
> How can i get only specific?

Do you want the ONE row that's closest, or a set of rows that are fairly
close?  Not sure what your specification it exactly, but how about:

select name where '2660124' between start and end order by abs
(start-end) limit 1;

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: CURRENT_TIMESTAMP vs actual time
Next
From: Janning Vygen
Date:
Subject: User def. Functions for sysadmin tasks?