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