Search Postgresql Archives

Re: Most specific match using between

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2005-04-21 at 10:51, mmiranda@xxxxxxxxxxxxxxxxx wrote:
> > 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;
>

I want the one row that is closest, your query seems to work...

---

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux