error can't select an agregate function

From: joerg(dot)naumann(at)miele(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: error can't select an agregate function
Date: 2002-03-11 10:12:37
Message-ID: 41256B79.0037F442.00@lnsmtp.miele.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

first sorry for my english but it`s not my natural language.

I've a question. These Days if made an update from postgresql 7.0 to 7.1 and
since this time I was unable to enter SQL-Queries like :
select sum(offline-online) from online;
where offline and online are attributes of time

The reported errormessage is like : error can't select from aggregate function.

Is it generally impossible since this version or do I have to configure
something.

I think this question is already discussed but please if someone find it useful
to tell me how often this question is allready postet please send me what I do
have to do to fix the problem and I'll never post a question again, because
everything else is working fine.

Regards Jörg

Browse pgsql-general by date

  From Date Subject
Next Message Jacob Vennervald Madsen 2002-03-11 10:18:01 How can I see which users are connected?
Previous Message Matthew D. Fuller 2002-03-11 09:54:58 Re: Postgres not starting at boot(FreeBSD) - startup script not releasing < solved