| From: | "Dhugael McLean" <box(at)yourtechonline(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #3260: Subtracting intervals |
| Date: | 2007-05-03 16:21:51 |
| Message-ID: | 200705031621.l43GLp7S051027@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3260
Logged by: Dhugael McLean
Email address: box(at)yourtechonline(dot)com
PostgreSQL version: 8.1.8
Operating system: FreeBSD
Description: Subtracting intervals
Details:
select '1 day'::interval - '55 minutes'::interval;
?column?
-----------------
1 day -00:55:00
If the interval periods are both minutes (hours - hours, days - days, etc),
this works fine. Days - minutes seems to fail. This should output 23:05:00.
In case this was some weird casting error, I checked:
select interval '1 day' - interval '55 minutes';
and that failed as well.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-05-03 17:06:23 | Re: BUG #3260: Subtracting intervals |
| Previous Message | Alvaro Herrera | 2007-05-02 14:02:35 | Re: PGSQL - WARNING: 25P01: there is no transaction in progress |