Re: BUG #4317: problem with comparision of datatype date

- 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(at)postnewspapers(dot)com(dot)au>
To: "Sanjay Rajdev" <sanjay(dot)rajdev(at)featherstoneinformatics(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)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