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: [EMAIL PROTECTED] > 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
