Re: What's wrong with this group by clause? - Mailing list pgsql-sql

From: Franco Bruno Borghesi <franco@akyasociados.com.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