Subject | View column datatype |
---|---|
Author | Fabiano Bonin |
Post date | 2008-06-18T13:14:48Z |
Hi all,
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;
Regards,
Fabiano
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;
Regards,
Fabiano