>>Martin Catherall wrote:
>>>I would like to select data from a table / stored procedure into
>>>another table that does not exist.
>>>
>> I responded
>>That's not possible.
>>
>>Thomas Miller wrote:
> To bad because it is a great short cut for developers.

It's being discussed on the architecture list. There are several
problems.

One is that Firebird metadata updates must be committed before the thing
being defined can be used. That's hard to do in the middle of a select.

Another is the scope of the table created - who can see it and when does
it go away. There's a general feeling that only the connection that
caused the table to exist can see it and that it should go away when
that connection ends. That feeling is not shared by front-ends
(JayBird for example) that specialize in connection sharing.

Another issue is the relationship of the feature to the SQL standard.
The standard describes two types of temporary tables, neither of which
fits very well.

There are also questions of performance - particularly on clean-up if
the connection fails...

Regards,


Ann