Re: select id,count(imdb_id) problem

am 10.04.2006, um 8:28:12 +0300 mailte Ntina Papadopoulou folgendes:
> Hello community!
>
> When I type a query in postgresql, like
>
> select id,imdb_id,count(imdb_id) from "Movies" where id<10 group by
> imdb_id;
>
> it says: column "Movies.id" must appear in the GROUP BY clause or be used
> in an aggregate function
> Where is the error?

The column 'Movies.id' isn't in the group by clause.

> What is the right spelling of this query?

select id,imdb_id,count(imdb_id) from "Movies" where id<10 group by
id,imdb_id;

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===