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

31 Jan 2006

      On 31-01-2006 19:01:53 +1000, Lee Marks wrote:
...
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?
Is this within a transaction or not?

Does this work for example:

START TRANSACTION;

CREATE LOCAL TEMPORARY TABLE foo (abc integer); 
INSERT INTO foo VALUES(1);
INSERT INTO foo VALUES(2);
SELECT * FROM foo;

COMMIT;

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

Fabian Groffen