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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to