Re: [HACKERS] Views which lead to nested aggregates

Malcolm Beattie wrote:

> ...
> gives the same message. I'm not familiar with postgres internals but
> it looks as though the internal handling of views is still having
> trouble with those two levels of aggregations despite the underlying
> queries being OK. As a data point, the view creation and queries work
> fine under Informix IDS 7.3 and Sybase. Is this problem with postgres
> something which is a fixable bug, a missing feature request that is
> planned to arrive soon (maybe it's in 6.5?) or a missing feature which
> isn't going to happen any time soon?

Up to now (v6.5) this kind of nested aggregates isn't
supported. Not directly over SQL, nor by views. To be sure
anything is fine, your views (and however you select from
them) should be expressable with a regular SELECT too. In
fact the rewrite system has to try to build such a query for
it - so if you can't how should the rewriter can?

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#========================================= wieck(at)debis(dot)com (Jan Wieck) #