Hi,

> When i open the view created below in IBExpert, it reports "column1"
> as numeric(18,2).
> Is it expected?
>
> Tested with FB 2.1 and FB 2.0.4
>
> create view test (
> column1 )
> as
> select
> cast(0 as numeric(11,2)) as column1
> from
> rdb$database;

If this is a "dialect 1" database, then yes.

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