Re: BUG #4276: Feature request aggregate indexes

On Tue, 2008-07-01 at 13:27 +0000, x wrote:
> The following bug has been logged online:
>
> Bug reference: 4276
> Logged by: x
> Email address: noreply(at)postgresql(dot)org
> PostgreSQL version: n/a
> Operating system: n/a
> Description: Feature request aggregate indexes
> Details:
>
> # CREATE INDEX count_star ON fscrbank (COUNT(*));
> ERROR: cannot use aggregate function in index expression
>
> Don't know how the architechture would handle it but this should be
> possible.

The developers agree this is a good idea. It is already on the TODO,
described as "materialized views", though I like your name for it also,
since that is the main use case.
http://www.postgresql.org/docs/faqs.TODO.html

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support