Subject Re: [ib-support] Domains and decimals
Author Claudio Valderrama C.
""Leeway"" <lee@...> wrote in message
> I have a lot of floating fields in my database all assigned to a
> domain.
> I want all those fields truncated to 4 digits after the decimal point.
> Is there a way to do this without truncating them in the program, but
> thruncating them in the database ?

Use dialect 3 and a numeric field with 4 decimal digits. Or if your field is
already FLOAT and you don't want to change it, you could try to cast it to
numeric(N,4) in dialect 3, but it will be slow if you do the conversion on
each query, better redefine your field.