At 10:38 AM 11/23/2004, Martijn Tonies wrote:

>Paul,
>
> > Syntax:
> >
> > CREATE TEMPORARY TABLE <table name> <table contents source>
> > [ON COMMIT {PRESERVE | DELETE} ROWS]
>
>CREATE GLOBAL TEMPORARY TABLE
>
>for tables that are accessible over connection boundaries.

That's not what the standard specifies. The GLOBAL|LOCAL qualifier
affects the scope of tables across modules invoked by a connection.
Since we don't do modules, it's moot. Since we might sometime do
modules, we shouldn't give different semantics to reserved syntax.


Regards,


Ann