Vlad,

>> with the limitations above, not much. But I am a little lost as to how
>> the original requirements from Volker Rehn generated this whole

V> Sorry, i don't know about "original requirements from Volker Rehn"

so where has the input for this work come? Who is eagerly waiting for
temporary tables as described by Ann?

>> Scoped table/cursor variables (with table/cursor as a
>> datatype) are what Firebird needs IMHO.

V> Is this that what i named 'local declared temporary tables' ?

pretty much so, although it has been agreed upon (I believe) that a
stored procedure (or a trigger, or a PSQL block) cannot be considered
a SQL-client-module in SQL-standard parlance, which invalidates the
whole idea. That's what I catched from this rather chaotic discussion.
It may well be off base and certainly contributes to increase the
entropy. ;-)

Ciao
--
Nando Dessena
http://www.flamerobin.org