Tom,
Thanks for the thought, I think that this can be the problem, as earlier there was no indexing on the column, but 2
daysback we added index on 5 of columns in the table and "somedate" is one of them. This problem have been noticed
afterthe index's were added.
I can't test this out as this happens while people are using the software, and when someone complains, we have to fix
itimmediately we can't have people wait for the re-indexing to be done.
For fixing it we just update the date to some other date and then update it back to what was originally, this way it
works.Any suggestion to get it fixed.
Regards,
Sanjay Rajdev
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Sanjay Rajdev" <sanjay.rajdev@featherstoneinformatics.com>
Cc: pgsql-bugs@postgresql.org
Sent: Friday, July 18, 2008 10:17:03 PM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi
Subject: Re: [BUGS] BUG #4317: problem with comparision of datatype date
"Sanjay Rajdev" <sanjay.rajdev@featherstoneinformatics.com> writes:
> Here is what is happening, I have a datatype "date" column in my database
> called "somedate" there are 277 rows in the database which have "somedate" =
> "2008-07-18".
> When I execute the below query
> "select * from myTable where somedate = '2008-07-18'"
> I only get 145 rows back from the database.
Is there an index on somedate, and if so does reindexing it help?
regards, tom lane