Re: [MonetDB-users] MonetDB-SQL 2.10.0 - Status of temorary tables?

Hi Niels, On Tue, 31 Jan 2006 07:58:04 +0100 Niels Nes wrote:

indeed the syntax is slightly wrong. Try the following statement instead.

create local temporary table foo (abc integer);

Thanks, this works though not quite as I had expected! The created temp table only persists for the duration of a single batch execution rather than for the duration of the connection. In other words, if I say create local temporary table foo (abc integer); insert into foo values(1); insert into foo values(2); select * from foo; 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? Thanks, Lee