Re: Bug #443: Problem with time functions.

> timetest=# select  sum(timeend-timebegin) as totaltime from timetest;
> ERROR:  Unable to select an aggregate function sum(time)

Hmm. The underlying math works:

lockhart=# select time '10:01' - time '10:00';
----------
 00:01:00

lockhart=# select sum(time '10:01' - time '10:00');
ERROR:  Unable to select an aggregate function sum(time)

A workaround for this last query is

lockhart=# select sum(cast(time '10:01' - time '10:00' as interval));
  sum
-------
 00:01

hth

OK. Bruce, are you likely to be keeper of a "fix list" for this beta
cycle? This issue should be on it...

                    - Thomas