> >I wanted implement something like Materialized View.
>
> Why you need "something like Materialized View" when you can
> implement real materialized view with table and set of triggers?
>
> >It is possible to use external table created at runtime of stored
> >procedure and then immediately insert into it? In oracle this is
> >possible...
>
> In Firebird this is the fastest way to kill database.

If that is the case, then it shouldn't be possible.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com