> 1) Create a stored procedure that deletes all rows from the
> table and stores a new set, using the select statement that
> would have been included in the view definition. Run the
> stored procedure periodically. This emulates the Oracle
> semantics.

In the light of a recent discussion about temporary tables, I see some
beauty in the following syntax to do (re)population of such a
pseudo-view:

RECREATE TABLE mat_view AS
SELECT * FROM table1 INNER JOIN table2 ON ... WHERE ...