Date calculation produces wrong output with 7.02

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Date calculation produces wrong output with 7.02
Date: 2001-02-23 17:18:15
Message-ID: 200102231718.f1NHIFd84626@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Mark Stosberg (mark(at)summersault(dot)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 let me know something is fault.

Sample Code

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-02-23 17:40:40 Re: Date calculation produces wrong output with 7.02
Previous Message Leonid Furman 2001-02-23 17:04:28 delete fails due to referential integrity, but return code is 0.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-23 17:40:40 Re: Date calculation produces wrong output with 7.02
Previous Message Andy Engdahl 2001-02-23 16:58:45 PostgreSQL JDBC