> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
