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
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 |