Subject | Re: [ib-support] INF in NUMERIC field |
---|---|
Author | Ivan Prenosil |
Post date | 2002-08-07T10:30:05Z |
> I just had a DB where I had a table with a field VALBELOB defined asINF means "Infinity". It is a "state" that can be stored
> NUMERIC(15,2) default 0.
>
> I contained the value INF
>
>
> What does that mean ?
(along with "Negative Infinity" and "Not a Number")
in floating point values.
You should avoid using them in IB/FB, because these values
are not sometimes handled correctly and can lead to server crash.
(I never know whether in text I should use IB or FB or IB/FB.
It's like he/she problem :-)
Ivan
http://www.volny.cz/iprenosil/interbase