Regression from 7.3 to 7.4

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Regression from 7.3 to 7.4
Date: 2004-04-05 06:40:40
Message-ID: Pine.LNX.4.44.0404050836480.4551-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This testcase works in 7.3 but not in 7.4:

------------------------------------------

create table t1 (a int);
create table t2 (b int);

select * from t1, (select b as a from t2 group by a) as foo;

------------------------------------------

ERROR: column "t2.b" must appear in the GROUP BY clause or be used in an
aggregate function

I don't know if it's supposed to work to do a group by of an alias, but
why not and it used to work.

--
/Dennis Björklund

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2004-04-05 09:05:53 Re: Function to kill backend
Previous Message Bruce Momjian 2004-04-05 05:43:22 Re: thread_test.c problems