On Thu, Apr 21, 2005 at 09:51:16AM -0600, mmiranda(at)americatel(dot)com(dot)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?
....ORDER BY end-start ASC LIMIT1; ?
Cheers,
Steve