Subject | computed fields: no control on data type ? |
---|---|
Author | duilio_fos |
Post date | 2002-11-02T11:11:52Z |
I define a computed field as
alter table ATable add AValue computed by (Qty*Price)
(here both Qty and Price are of type Numeric(15,5) ).
FB creates the new field of type Double Precision.
This brings me a few problems.
I would have preferred a field of type Numeric(15,5) , but I guess
there is nothing to do...
Or not ?
TIA
Duilio Foschi
alter table ATable add AValue computed by (Qty*Price)
(here both Qty and Price are of type Numeric(15,5) ).
FB creates the new field of type Double Precision.
This brings me a few problems.
I would have preferred a field of type Numeric(15,5) , but I guess
there is nothing to do...
Or not ?
TIA
Duilio Foschi