> Thanks for this tip very useful and simple idea. As a thought could
> 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.

Identity is different from generators. Actually, generators (also called
"sequences" are superior.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com