group by problem

Matthias Teege wrote:

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?

Write:

group by T1.id, T1.name, T1.zusatz, T1.kontakt, T1.strasse,
T1.land, T1.plz, T1.ort, T1.telefax

IMHO you must 'group' on all selected rows by except
aggregated rows.

With best regards, Max Vaschenko,
Nizhny Novgorod Information Networks.