>>> On Fri, Jul 18, 2008 at 2:35 PM, in message
<[EMAIL PROTECTED]>,
Sanjay Rajdev <[EMAIL PROTECTED]> wrote:
> Thanks for the thought, I think that this can be the problem, as
earlier
> there was no indexing on the column, but 2 days back we added index
on 5 of
> columns in the table and "so
+05:30 Chennai, Kolkata, Mumbai,
New Delhi
Subject: Re: [BUGS] BUG #4317: problem with comparision of datatype date
"Sanjay Rajdev" <[EMAIL PROTECTED]> writes:
> Here is what is happening, I have a datatype "date" column in my database
> called "somedate&q
raig 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
S
"Sanjay Rajdev" <[EMAIL PROTECTED]> 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-0
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?
- C
The following bug has been logged online:
Bug reference: 4317
Logged by: Sanjay Rajdev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: Window Server 2003
Description:problem with comparision of datatype date
Details:
I installed a new Po
