Re: BUG #4317: problem with comparision of datatype date

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Sanjay Rajdev <sanjay(dot)rajdev(at)featherstoneinformatics(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4317: problem with comparision of datatype date
Date: 2008-07-18 16:38:39
Message-ID: 4880C70F.7020602@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sanjay Rajdev 2008-07-18 16:44:27 Re: BUG #4317: problem with comparision of datatype date
Previous Message Dave Page 2008-07-18 16:18:11 Re: BUG #4312: Installation fails