On Mon, 23 Oct 2000 jan.bajerski@viterra.pl wrote:
> Hello,
> I have following problem with PostgreSQL 6.5.3, I haven't possiblity
> to check it on 7.0 and I want to know is it possible to run such query:
>
> SELECT k.pic, id_g, id_k, count(*)
> FROM kart k, pictues p
> WHERE k.pic = p.pic
> GROUP BY k.pic
>
> PICTURES(pic,id_g,id_k)
> KART (pic,email,mess,date)
>
> I've got answer from Postgres
> "Illegal attributes or non-group column"
>
> Is it error in query or in parser ?
AFAICS, the above construct isn't a legal
GROUP BY query. All columns in the select
list must either be grouped columns or
in some sort set value function.
Assuming that pictures.pic is unique, you
can add p.id_g and p.id_k to the group
by clause. Otherwise, you need to decide
which id_g and id_k you want (min or
max is often useful).