Andrea Aime wrote:
>
> Hi people. I would like to make a query that
> tells me how many distinct values there are
> in a column. Standard count doesn't seems
> to support a count distinct option.
> select distint count(*) of course doens't
> work (distinti clause is applied after the
> result are
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
