Re: BUG #4317: problem with comparision of datatype date - Mailing list pgsql-bugs

From Craig Ringer
Subject Re: BUG #4317: problem with comparision of datatype date
Date
Msg-id 4880C70F.7020602@postnewspapers.com.au
Whole thread Raw
In response to BUG #4317: problem with comparision of datatype date  ("Sanjay Rajdev" <sanjay.rajdev@featherstoneinformatics.com>)
List pgsql-bugs
Sanjay Rajdev wrote:

> If I execute
> "select * from myTable where somedate between '2008-07-18' and
> '2008-07-18'"
> I get all 277 rows.

I'm not able to help you out directly (just another user) but answering
the following questions might help others:

- What was the previous database version?
- Can you provide DDL for the table?
- What is the exact data type of the field `somedate' ?

--
Craig Ringer

pgsql-bugs by date:

Previous
From: "Dave Page"
Date:
Subject: Re: BUG #4312: Installation fails
Next
From: Tom Lane
Date:
Subject: Re: BUG #4317: problem with comparision of datatype date