Re: [GENERAL] Subtracting Two Intervals

2008-04-07 Thread Bruce Momjian
Terry Lee Tucker wrote: > In porting from 7.4.19 to 8.3.1 I have found the following: > > 7.4.19: > mwr=# select interval '1 day 15 hours 30 minutes' - interval '29 hours'; > ?column? > > @ 10 hours 30 mins > (1 row) > > 8.3.1: > mwr83=# select interval '1 day 15 hours

[GENERAL] Subtracting Two Intervals

2008-04-07 Thread Terry Lee Tucker
In porting from 7.4.19 to 8.3.1 I have found the following: 7.4.19: mwr=# select interval '1 day 15 hours 30 minutes' - interval '29 hours'; ?column? @ 10 hours 30 mins (1 row) 8.3.1: mwr83=# select interval '1 day 15 hours 30 minutes' - interval '29 hours';