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.htmlthis 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
