Search Postgresql Archives

Re: complicated query (newbie..)

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

 



On Thu, Apr 09, 2009 at 08:16:55PM +0200, Marcin Krol wrote:
> Sam Mason wrote:
> >On Thu, Apr 09, 2009 at 07:25:42PM +0200, Marcin Krol wrote:
> >>SELECT h.id, r.id, r.start_date, r.end_date
> >>  FROM hosts h
> >>    LEFT JOIN (reservation_hosts m INNER JOIN reservation r
> >>        ON m.reservation_id = r.id
> >>        AND (r.start_date,r.end_date) OVERLAPS 
> >>        ('2009-04-09'::date,'2009-04-10'::date))
> 
> >The dates here are the date range that you want to give to the user; I
> >was assuming that just because somebody doesn't have a reservation at
> >the moment you still don't want to put reservations going backwards and
> >forwards to infinity.
> 
> Not backwards, but forward into some reasonable range, like 3 months (I 
> want the user to see the nearby reservation in future).

I'm not sure if this is a question or something else.  If you're
wondering how to do this just use a range of ('2009-01-01'::date,
'2009-12-31'::date) to show all entries for this year.

-- 
  Sam  http://samason.me.uk/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[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