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