Most specific match using between - Mailing list pgsql-general

From mmiranda@americatel.com.sv
Subject Most specific match using between
Date
Msg-id 76E0DAA32C39D711B6EC0002B364A6FA043DCDF7@amsal01exc01.americatel.com.sv
Whole thread Raw
Responses Re: Most specific match using between  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Most specific match using between  (Steve Atkins <steve@blighty.com>)
List pgsql-general
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?


thanks

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: CURRENT_TIMESTAMP vs actual time
Next
From: Alban Hertroys
Date:
Subject: Re: CURRENT_TIMESTAMP vs actual time