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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general