Date calculation produces wrong output with 7.02 - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Date calculation produces wrong output with 7.02
Date
Msg-id 200102231718.f1NHIFd84626@hub.org
Whole thread Raw
Responses Re: Date calculation produces wrong output with 7.02  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Mark Stosberg (mark@summersault.com) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Date calculation produces wrong output with 7.02

Long Description
I use Postgres nearly every day and am very appreciative of the project.

I think this example will my bug:

[PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc 2.96]
cascade=> select date(CURRENT_DATE + ('30 days'::reltime));
      date
----------
9097-10-20

#############

It's quite likely my "date math" syntax is wrong, but it seems that Postgres should either return the right result, or
letme know something is fault.  

Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: "Rainer Mager"
Date:
Subject: RE: Problem with 7.0.3 dump -> 7.1b4 restore
Next
From: Tom Lane
Date:
Subject: Re: Date calculation produces wrong output with 7.02