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

From Ntina Papadopoulou
Subject select id,count(imdb_id) problem
Date
Msg-id 4439ECEC.1060601@freemail.gr
Whole thread Raw
Responses Re: select id,count(imdb_id) problem
List pgsql-novice
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?
What is the right spelling of this query?

____________________________________________________________________
http://www.freemail.gr - δωρεάν υπηρεσία ηλεκτρονικού ταχυδρομείου.
http://www.freemail.gr - free email service for the Greek-speaking.

pgsql-novice by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: replication
Next
From: "A. Kretschmer"
Date:
Subject: Re: select id,count(imdb_id) problem