Re: [BUGS] BUG #3260: Subtracting intervals

2007-05-03 Thread Alvaro Herrera
Dhugael McLean wrote: > 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. No, th

Re: [BUGS] BUG #3260: Subtracting intervals

2007-05-03 Thread Tom Lane
"Dhugael McLean" <[EMAIL PROTECTED]> writes: > 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

[BUGS] BUG #3260: Subtracting intervals

2007-05-03 Thread Dhugael McLean
The following bug has been logged online: Bug reference: 3260 Logged by: Dhugael McLean Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: FreeBSD Description:Subtracting intervals Details: select '1 day'::interval - '55 minutes'::interval;