Is this a parser error ?

From: Shiby Thomas <sthomas(at)cise(dot)ufl(dot)edu>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Is this a parser error ?
Date: 1998-02-04 17:56:53
Message-ID: 199802041757.MAA11021@cise.ufl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

assoc=> explain insert into f2_temp select p.item, q.item, count(*) as cnt
from t1 p, t1 q where p.tid = q.tid and p.item < q.item group by p.item,
q.item;
ERROR: The field being grouped by must appear in the target list

However, it works this way:
assoc=> explain select p.item, q.item, count(*) as cnt into table f2_temp from
t1 p, t1 q where p.tid = q.tid and p.item < q.item group by p.item, q.item;
NOTICE: QUERY PLAN:

--shiby

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-02-04 17:57:48 Re: [HACKERS] Re: [QUESTIONS] is Postgres an SQL-based database?
Previous Message Bruce Momjian 1998-02-04 17:47:32 Re: [HACKERS] Hi