Re: [SQL] CTEs and re-use

> On Apr 11, 2017, at 8:47 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> On Tuesday, April 11, 2017, Rob Sargent <robjsargent@gmail.com> wrote:
>
> I’m really just bumping into the annoyance of manually dropping the temp table as I work this up (though real
collisionin production would is possible, it would be unlikely) and thought to try to rework the function without the
temptable - that’s the SQL question - and presumed the specifics of the function would come in useful. 
>
>
> I'm not positive what you are thinking here but the names of temporary tables are session-unique.  They are not prone
toconcurrent use namespace collisions and not do not interfere with permanent tables either.  They are placed into a
temporaryschema that is only visible to the current session. 
>
> David J.
Of course ‘on commit drop’ works like a charm.
Thanks a ton.
rjs