Re: UPDATEABLE VIEWS ... Examples?

> >This is maybe a newbie question, but what is the difference with a
> >materialized view ?
>
> As I understand it (and that understanding may be wrong) a
> materialized view is a table that holds the values of a view from
> some point in time. A view is a "saved" subselect. Everything you
> call a view, the PostgreSQL backend re-evaluates the definition of
> the view. A materialized view is only as accurate as the last time it
> was updated. Things such as triggers can be used to keep the
> materialized view updated. The key issue with materialized views is
> to make sure it's always up-to-date with the evaluation of the view.

Thanks Michael, I already know what is a materialized view. I often use
them, systematically updated with some triggers.
It's an updatable view that i didn't knew.

It opens some perspectives in programmation, methinks :-)

Thanks all the same,
David

--
dpradier(at)apartia(dot)fr - tel: 01.46.47.21.33 - fax: 01.46.47.21.37