select sum() possible or not ?
От
joerg.naumann@miele.de
Тема
select sum() possible or not ?
Дата
Msg-id
41256B7C.00288739.00@lnsmtp.miele.de
Список
Дерево обсуждения
select sum() possible or not ? joerg.naumann@miele.de
Re: select sum() possible or not ? Stephan Szabo <sszabo@megazone23.bigpanda.com>
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
В списке pgsql-general по дате отправления