You can take a look to postgre DataTypes an you ll see a leack , i use firebird and i dont wanna change i like it but it have some probs or forgoten Improvements.
How can firebird be improved to be the best of the best.
Complex Datatype (Record/Struct on a field), Like PostGreSql. (Several child fields under a field.)
AutoInc DataType - Like Serial PostGre to avoid the use of Trigger -> it should trigger auto the generator.
XML Support - Extremely useful and and remove chils of a xml data.
Calc DataType - Calculate on the fly. is useful because it will be a static field on db - This is usefull for Visual IDE dev.
Aggregate Fields - Extremely usefull.
Boolean DataType - Supposet it will on fb version 3 , (It will be usefull to be a 0 -1 or F - T Char)
- Network Address Types - 8.9.1. inet - 8.9.2. cidr - 8.9.3. inet vs. cidr - 8.9.4. macaddr
- TableField - Datatype - To store tables under a field
1 st Type - To be a table under a field. - Should be an external table but only acessible from this field.
2 nd Type - To be a Table under a field - But To store all Table under the field including structure of the table .
3 rd Type - To be a Static Table under a Blob (the table stucture is always the same)
On the 1st - the table definitions is stored on the table outside the field -should be usefull to this to Point to a table dinamicly - we may point in diferent rows to diferent Tables.
On 2 nd - the field is a blob to store all tabledata and structure (I do this with blobs load and save but the prob is this is not automaticly).
This means each row can have a diferente table ...
On the 3rd - the table definitions is only stored once on the field and the blob stored is only data match is fields header structure.