On Fri, 24 Aug 2001, Joseph Shraibman wrote:
> playpen=# select a, sum(b) as dsum from taba where dsum > 5 group by(a);
> ERROR: Attribute 'dsum' not found
>
> Why can we GROUP BY on an alias but not do a WHERE on an alias? I have a subselect that
> explain shows is being run twice if I have to put it in the WHERE clause.
Somewhat unrelated question, are you sure you want where and not having?
IIRC, where is going to select rows before things like the group by
occur, and that doesn't seem to be what you'd want here, right?