Re: select id,count(imdb_id) problem - Mailing list pgsql-novice

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    ===