"skander_sp" <skander_sp@...> wrote:

>
> Creating a computed field (that work fine in 1.5.3) give an error in 2.0
>
> ALTER TABLE S1 ADD BASE COMPUTED BY (
> cast(
> coalesce(
> (select sum(cast(s2.cantidad*s2.Precio as numeric(14,4))
> *cast((1.0-s2.dto/100)*(1.0-s1.dto/100) as numeric(6,5)))
> from s2
> where a1.id = s2.id)
> ,0)
> as numeric(14,2)));

What are the datatypes of "cantidad", "precio" and "dto"? It looks like any
of them is a string.


Dmitry