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

[Len Morgan]

From: Franco Bruno Borghesi <[EMAIL PROTECTED]>
>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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster