Tom Lane wrote:
> View? Hmm, we know that views involving GROUP BY or aggregates
> don't work very well. We hope to fix those problems in 7.2, but
> right now there's probably not much that can be done about it.
> I'd recommend avoiding views that use those features for now.
Yes, I've just dis
Paul McGarry wrote:
> If I do a 'SELECT * from view_name' and get 8 rows of data, when I
> do a 'SELECT count(*) from view_name' I get 8 rows of the
> number 1 returned.
I've attached a script which will generate a bunch of tables and
a view then do a select * and select count(*) on that view.
Hi Tom,
Tom Lane wrote:
> > ERROR: ExecEvalAggref: no aggregates in this expression context
> > Does it mean that there aren't any aggregate in the expression
> > context when there should be.
> Yup. ExecEvalAggref is supposed to fetch the result of a (previously
> computed) aggregate function.
