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