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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to