pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: jan.bajerski@viterra.pl
To: pgsql-sql@hub.org
Date: Mon, 23 Oct 2000 17:11:06 +0200
Message-ID: <OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl> (raw)

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






view thread (5+ messages)  latest in thread

Message-ID: <OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl>
Permalink:  ../OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl/
Also on:    postgresql.org/message-id/OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jan.bajerski@viterra.pl, pgsql-sql@hub.org
  Subject: Re: 
  In-Reply-To: <OF425EBB1A.C55A43AC-ONC1256981.00534C67@viterra.pl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox