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
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. |
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 |