Обсуждение: group by problem

Поиск
Список
Период
Сортировка

group by problem

От
Matthias Teege
Дата:
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

Re: group by problem

От
Vashenko Maxim
Дата:
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.