- 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" <[EMAIL PROTECTED]> To: "Sanjay Rajdev" <[EMAIL PROTECTED]> 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
