On Tue, Apr 21, 2009 at 12:02:02PM +0100, Geoff Caplan wrote: > Looks like there's something I'm not understanding about > date/time queries on a date field. [...] > date/time field value out of range: "2011-4-31" As far as I'm aware; April only has 30 days. You're asking PG for an invalid date and this is its way of telling you so! -- 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