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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
