Re: What's wrong with this group by clause?

From: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
>SELECT
> 0 AS field1,
> 0 AS field2,
>name
>FROM
> people
>GROUP BY
> field1,
> field2,
>name;

I think the problem is that you don't have a column to group on. Try adding
SELECT ....,count(*).... so that there is an aggregate of some kind.
Alternatively, you could use DISTINCT ON (field1,field2) field1,field2,name
FROM ... although this is a Postgres specific extension of the SQL spec.

Len Morgan