Hi Set,

>I think what Alex talked about, was a different type of derived tables:
>
> "That I very much wish to see in firebird is derived tables - an ability to (sorry, DDL syntax is invited on the run,
> and I prefer this sample to long description):
>
> CREATE TABLE BASE_TABLE (X BIGINT NOT NULL PRIMARY KEY, Y VARCHAR(255));
> CREATE TABLE DERIVED_TABLE BASED ON BASE_TABLE (Z TIMESTAMP); COMMIT;
>
> INSERT INTO BASE_TABLE VALUES (1, 'abc'); INSERT INTO BASE_TABLE VALUES (2, 'def');
> INSERT INTO DERIVED_TABLE VALUES (3, 'xyz', CURRENT_DATE); COMMIT;
>
> After this DERIVED_TABLE contains 1 record and BASE_TABLE - 3 records. This can be a great improvement to handle a lot
> of real word information."
>
> I haven't heard about this type of derived tables being implemented in Firebird yet, but found Alex' short description
> interesting (although it also made my head wonder why not extending the BASED ON clause to support both named fields
> (as opposed to always including the full table) and join clauses).
>
> Or am I using a so ancient Firebird version that I simply haven't noticed this new feature?

This sounds more like inheritance like classes in Delphi for example, so calling this derived tables is pretty much
confusing. I remember Nickolay talked also about this feature long time ago and sounds interesting to me too.

Would be nice if Alex is going to implement this kind of feature.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database with many powerful SQL features:
http://www.firebirdsql.org
http://www.firebirdsql.info

General database developer support:
http://www.databasedevelopmentforum.com

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info