Hi Nando,

> >>with the limitations above, not much. But I am a little lost as to how
> >>the original requirements from Volker Rehn generated this whole
> >>discussion about SQL standard temporary tables.
>
> A> That's easy. We set about the produce a design for temporary
> A> tables.
>
> That's the mistake I guess. Nobody wants temporary tables as defined
> by the SQL standard;

What makes you say that? As we have seen earlier, there are several
database systems that implement them just like the SQL standard says
you should. Why shouldn't we? (now or later)

>people appear to call "temporary tables" what is
> actually something different and perhaps doesn't even exist in the
> SQL standard. ;-)

And because people are used to lovely MS SQL Server.


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com