[GENERAL] select sum() possible or not ?

[joerg....@miele.de]

Hello,

I'm using PostgreSQL 7.1

I have a table like :

date logon logoff
---------------------------------
01-01-02 | 12:02:03 | 12:04:23
01-01-02 | 12:05:13 | 12:08:13
01-01-02 | 13:02:03 | 13:04:23
01-01-02 | 14:02:03 | 14:04:23
01-02-02 | 08:59:03 | 09:09:23
........

and I want to do the following select :

select sum(logoff - logon) from online;

but I receive a error that it's not possible to select a aggregate function
sum(time).

Does someone have an idea why, is there a configuration switch which could solve
the problem?

Thanks

Jörg Naumann

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majo...@postgresql.org)

[Stephan Szabo]

On Thu, 14 Mar 2002 joerg....@miele.de wrote:

> Hello,
>
> I'm using PostgreSQL 7.1
>
> I have a table like :
>
> date logon logoff
> ---------------------------------
> 01-01-02 | 12:02:03 | 12:04:23
> 01-01-02 | 12:05:13 | 12:08:13
> 01-01-02 | 13:02:03 | 13:04:23
> 01-01-02 | 14:02:03 | 14:04:23
> 01-02-02 | 08:59:03 | 09:09:23
> ........
>
> and I want to do the following select :
>
> select sum(logoff - logon) from online;
>
> but I receive a error that it's not possible to select a aggregate function
> sum(time).
>
> Does someone have an idea why, is there a configuration switch which could solve
> the problem?

I'd suggest upgrading to 7.2, it looks like the above works there.
Failing that maybe try a cast to interval? cast((logoff-logon) as
interval)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majo...@postgresql.org so that your
message can get through to the mailing list cleanly