From: jan(dot)bajerski(at)viterra(dot)pl
To: <pgsql-sql(at)hub(dot)org>
Subject:
Date: 2000-10-23 15:11:06
Message-ID: OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • Re: at 2000-10-23 16:30:56 from Stephan Szabo
  • Re: at 2000-10-23 16:44:59 from Tomas Berndtsson
  • Re: at 2000-10-23 18:09:08 from bmccoy
  • Large Objects at 2000-10-24 10:07:16 from Craig May

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2000-10-23 16:30:56 Re:
Previous Message Jan Wieck 2000-10-22 12:26:12 Re: foreign key introduces unnecessary locking ?