On 31-01-2006 10:08:07 +0100, Fabian Groffen wrote:
On 31-01-2006 19:01:53 +1000, Lee Marks wrote:
and execute the whole thing in one go, no problem. But I can't create the temp table first and then separately execute the insert and select statements. Is there any way to have connection-scoped persistence?
Ok, I looked it up in the SQL99 book. LOCAL and GLOBAL TEMPORARY TABLES should persist till the end of the SQL session, after which they are automatically dropped. Seems like an SQL session is defined as 'excution of one or more consecutive SQL statements by a single user'. It's not said that clear, but it looks as if the session indeed is equal to the life span of the connection. In that case it looks as if MonetDB/SQL's current way of doing it is wrong.