"Ann W. Harrison" <aharrison@...> wrote:

>
> > If this is an actual data set, then how does it differ from LTTs?
>
> Local temporary tables are defined in the SQL standard to have the
> scope of SQL modules. We don't (yet) implement SQL modules so local
> temporary tables are irrelevant and inapplicable to Firebird.

I proposed a valid solution which allows us to have what _we_ call LTTs and switch to the SQL-99 syntax if we'll agree some time (or never switch if we don't agree).

> The advantages of the proposed syntax over the syntax of the standard
> include 1) The declaration and modification of transient data sets are
> DML, so we don't get into the DML/DDL mire.

CREATE/DROP INDEX and DROP TDS are also DML? Interesting.

> 2) for the same reason,
> transient data sets can be used in procedures.

As well as LTTs, I'd suppose.

> 3) a tds can be used to
> redefine itself - through projection, union, join etc.

This may be useful. And at least this is something new.


Dmitry