Postgres Pro
Downloads
Home   >   mailing lists

Re: ON condition in LEFT OUTER JOIN doesn't work?! - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: ON condition in LEFT OUTER JOIN doesn't work?!
Date
Msg-id 49DE28D9.5070805@iol.ie
Whole thread Raw
In response to ON condition in LEFT OUTER JOIN doesn't work?!  (Marcin Krol <mrkafk@gmail.com>)
List pgsql-general
Tree view 
On 09/04/2009 17:34, Marcin Krol wrote:
> reservation.start_date > 2009-04-09)

You need to phrase it like this:

  ... reservation.start_date > '2009-04-09'::date ...

Try this and see what happens. :-)

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: Aurimas Černius
Date:
Subject: Re: complicated query (newbie..)
Next
From: Raymond O'Donnell
Date:
Subject: Re: Storing HTML: HTML entities being rendered in that raw form