Hi!
I noticed that following the manual,
'In the SQL92 standard, the new column name specified in an "AS" clause
may be referenced in GROUP BY and HAVING clauses. This is not currently
allowed in Postgres. '
To have this featur would ease work, especially when using nested
aggregates (which are currently broken for my 6.5.1: max(count(x)) is
broken ;=)
Maybe in one of the next releases ?
lG
John