The world rejoiced as [EMAIL PROTECTED] (Tom Lane) wrote: > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: >> Currently you can create temporary tables that are deleted at the >> end of the session. But how about temporary views? It's just a >> table with a rule so I don't imagine it would be terribly >> difficult. Are there any issues I havn't thought of? > >> While we're at it, what about temporary functions? > > AFAICS, anything created in the temp schema will get zapped at > backend shutdown. (It would be a good idea to rename > RemoveTempRelations and related functions in namespace.c if they are > going to be used to zap other sorts of objects, but they will work > as-is.) > > So this is doable with just a Small Matter of Programming to pass > the is-temp flag through from the grammar to wherever the object > gets created. > > Whether it's worth the trouble is another question. What's the > use-case?
It's where you create a temporary table to store some results, but then want to create a view on top of that, because that makes some funky self-join more convenient. I found myself wanting this very thing last night when generating a report. (Believe it or not!) -- "cbbrowne","@","ntlug.org" http://www3.sympatico.ca/cbbrowne/spreadsheets.html "It seems that perfection is attained not when nothing is left to add, but when nothing is left to be taken away." -- Antoine de Saint-Exupery. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
