I have a couple questions about Postgres and Views.
I am curious about what Postgres actually does in regards to views and
the internal steps that it takes.
Are these the steps that it takes for each query that includes a view?
1. Dynamically Creates a Temp table with the view's select statement.
2. Executes the sql command against the view
3. Postgres destroys the temp table.
I understand that Postgres is not SQL 92 compliant with views because it
does not support updatable views. Are there plans ever to support
updatable views?
Thanks,
Brian