> 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:
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"