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 <[EMAIL PROTECTED]> PGP Key ID: DB3C29FC ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
