Skip site navigation (1) Skip section navigation (2)

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

From: Sanjay Rajdev <sanjay(dot)rajdev(at)featherstoneinformatics(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4317: problem with comparision of datatype date
Date: 2008-07-18 16:44:27
Message-ID: 24026028.108171216399467113.JavaMail.root@mail.featherstoneinformatics.com (view raw or flat)
Thread:
Lists: 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(at)postnewspapers(dot)com(dot)au> 
To: "Sanjay Rajdev" <sanjay(dot)rajdev(at)featherstoneinformatics(dot)com> 
Cc: pgsql-bugs(at)postgresql(dot)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

Next:From: Tom LaneDate: 2008-07-18 16:47:03
Subject: Re: BUG #4317: problem with comparision of datatype date
Previous:From: Craig RingerDate: 2008-07-18 16:38:39
Subject: Re: BUG #4317: problem with comparision of datatype date

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group