On Apr 21, 2009 2:34pm, Merlin Moncure <mmoncure@gmail.com> wrote: > On Tue, Apr 21, 2009 at 7:02 AM, Geoff Caplan geoff@uviva.com> wrote: > > > Hi folks > > > > > > Looks like there's something I'm not understanding about date/time queries > > > on a date field. > > > > > > I have a param query that includes the statement: > > > > > > AND active_from_date > > > > > where $2 is a well-formed ISO date. > > > > > > Query works as expected when there are records in the result set. When the > > > result set is empty, PG throws an error: > > > > > > date/time field value out of range: "2011-4-31" > > > > "2011-4-31" is not a well formed ISO date. > > > > merlin > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general >