I was browsing through SQL92 and I noticed this, when discussing the
CREATE VIEW syntax:
"5) Any <table name> that is specified in the <query expression> shall
be different from the <table name> of any <temporary table
declaration>."
(<query expression> is the defintion of the view. This basically says
that you're not allowed to create views on temp tables.)
Currently, PostgreSQL allows this -- when the session ends and the temp
table is dropped, an subsequent queries on the view fail. Is this the
optimal behavior?
Cheers,
Neil
--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC