Subject Re: [firebird-support] create table as select
Author Jack Engleman
I believe the Quell Language used in the INGRESS database some 25 to
years ago supported temporary
table creation and it was a big reason, why many users of Quell did not
like to switch to SQL, the Standard
promoted by IBM. Temporary tables are a tool used to solve some
difficult problems, I can easily say that
over 7 years in programming and maintaining an application using DELPHI
and Interbase/Firebird, that is the
one feature that I would find to be the most useful feature that could
be added. Many new features are icing
on the cake, but this feature would increase my productivity immediately.

Many times I would like to hold calculated values in a table with
additional information produced by
several queries and then sorting the results for display and reports.

Best Regards
Jack Engleman

Dimitry Sibiryakov wrote:
> On 17 Jul 2006 at 9:50, Nando Dessena wrote:
> >Recently I have used the feature in MS SQL for ordinary DBA work, and
> >found it very useful. I created a lot of tables and dropped none. :-)
> >Nothing that couldn't be done by good admin/client tools, but having
> >the feature in SQL is just handy.
> It is handy but it is against relation theory. Normalization! Why
> you can want to have two tables in a database with the same structure
> and the same data?..
> --
> SY, Dimitry Sibiryakov.