Re: ON condition in LEFT OUTER JOIN doesn't work?!

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Marcin Krol <mrkafk(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ON condition in LEFT OUTER JOIN doesn't work?!
Date: 2009-04-09 16:56:57
Message-ID: 49DE28D9.5070805@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-04-09 16:59:35 Re: Storing HTML: HTML entities being rendered in that raw form
Previous Message Aurimas Černius 2009-04-09 16:54:43 Re: complicated query (newbie..)