group by problem

From: Matthias Teege <matthias(at)mteege(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: group by problem
Date: 2000-06-15 07:35:23
Message-ID: 200006150735.JAA13875@moon.mteege.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Moin,

i have an sql query which works perfect under PostgrSQL
6.0 but under 6.5.1 it brings: ERROR: Illegal use of
aggregates or non-group column in target list.

select T1.id, T1.name, T1.zusatz, T1.kontakt, T1.strasse,
T1.land, T1.plz, T1.ort, T1.telefax
from debitoren T1, auftrag T2
where T2.kunde=T1.id
group by T1.id;

Where is the problem?

Thanks for any hints

Bis dann
Matthias

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert 2000-06-15 08:04:23 Q: regcomp failed with error invalid character range
Previous Message Tatsuo Ishii 2000-06-15 05:53:39 Re: Large objects