|Subject||Re: [Firebird-Architect] Re: Indexed Views|
> Thanks for this tip very useful and simple idea. As a thought couldIdentity is different from generators. Actually, generators (also called
> the engine not implement the keyword "materialized" when creating a
> view and do this plumbing work in the background for you? In theory
> shouldn't be too difficult as you are using parts of the engine that
> already exists.
> Like wise it would be nice t label a column as IDENTITY and it
> automaically adds a generator and a trigger for INSERT. Just reduced
> the amount of manual plumbing necessary.
"sequences" are superior.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL