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?

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Arno Brinkman
Sent: 2. desember 2009 10:40
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Derived tables

Hello,

>I have read recently a comment from Alex Peshkov about that he is working in derived tables feature.
> Do somebody when this feature will be available?

Derived tables are already implemented in Firebird some time ago, so this is already available.

Regards,
Arno Brinkman
ABVisie