Skip site navigation (1) Skip section navigation (2)

Re:

From: <bmccoy(at)chapelperilous(dot)net>
To: jan(dot)bajerski(at)viterra(dot)pl
Cc: pgsql-sql(at)hub(dot)org
Subject: Re:
Date: 2000-10-23 18:09:08
Message-ID: Pine.LNX.4.10.10010231405460.3868-100000@chapelperilous.net (view raw or flat)
Thread:
Lists: pgsql-sql
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.


In response to

  • at 2000-10-23 15:11:06 from jan.bajerski

pgsql-sql by date

Next:From: Vadim MikheevDate: 2000-10-23 18:22:28
Subject: Re: foreign key introduces unnecessary locking ?
Previous:From: najm HashmiDate: 2000-10-23 17:25:45
Subject: Need info: pl/pgsql performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group