Re: Materialized Views

hi mike

> In particular I'm interested in a view which materializes whenever
> queried, and is invalidated as soon as underlying data is changed.

from the german pgsql list earlier last week:

http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html

this seems to be pretty much what you want (except you'll have to update
everything yourself). would be really nice if pgsql supports this "in-house"

cheers,
thomas