Re:

On Mon, 23 Oct 2000 jan(dot)bajerski(at)viterra(dot)pl wrote:

> 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(*)
^^^^ ^^^^
What table do these come from?

> FROM kart k, pictues p
^^^^^^^^
This looks like a typo

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

Probably the query.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
The goys have proven the following theorem...
-- Physicist John von Neumann, at the start of a classroom
lecture.