- What was the previous database version?
8.1
- Can you provide DDL for the table?
No, company policies does not allow that.
- What is the exact data type of the field `somedate' ?
datatype is "date"
Regards,
Sanjay Rajdev
----- Original Message -----
From: "Craig Ringer" <craig@postnewspapers.com.au>
To: "Sanjay Rajdev" <sanjay.rajdev@featherstoneinformatics.com>
Cc: pgsql-bugs@postgresql.org
Sent: Friday, July 18, 2008 10:08:39 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Re: [BUGS] BUG #4317: problem with comparision of datatype date
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