Re: BUG #4317: problem with comparision of datatype date - Mailing list pgsql-bugs

From Sanjay Rajdev
Subject Re: BUG #4317: problem with comparision of datatype date
Date
Msg-id 24026028.108171216399467113.JavaMail.root@mail.featherstoneinformatics.com
Whole thread Raw
In response to BUG #4317: problem with comparision of datatype date  ("Sanjay Rajdev" <sanjay.rajdev@featherstoneinformatics.com>)
List pgsql-bugs
- 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@postnewspapers.com.au>
To: "Sanjay Rajdev" <sanjay.rajdev@featherstoneinformatics.com>
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4317: problem with comparision of datatype date
Next
From: "Kevin Grittner"
Date:
Subject: memory leak in 8.2.4