> > Hmm. The underlying math works:
...
> "Works" is in the eye of the beholder, perhaps.
Of course ;)
> ... I would think that the
> difference of two times should be an interval (which would allow the
> sum() to work, since we have sum(interval)). But there is no
> time-minus-time operator.
Thomas Lockhart <[EMAIL PROTECTED]> writes:
>> 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
"Works" is
> 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: Unab
Alessandro Rossi ([EMAIL PROTECTED]>) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Problem with time functions.
Long Description
Here is the DB and some sample entries.
CREATE TABLE "timetest" (
"id" serial primary key,
"timeb
