- Mailing list pgsql-sql

From jan.bajerski@viterra.pl
Subject
Date
Msg-id OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl
Whole thread Raw
Responses Re:
Re:
Large Objects
List pgsql-sql
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 ?    Yours Jan Bajerski





pgsql-sql by date:

Previous
From: "Continuing Technical Education"
Date:
Subject: Re: Conditional query plans.
Next
From: Jan Wieck
Date:
Subject: Re: [HACKERS] foreign key introduces unnecessary locking ?