Subject Re: INF in NUMERIC field
Author csswa
So how did the INF value get in there? The field is an integer, not
a float!? How is this 'state' represented internally?

Andrew Ferguson
-- If elected, Andrew will abolish all future elections.

--- In ib-support@y..., "Ivan Prenosil" <prenosil@m...> wrote:
> > I just had a DB where I had a table with a field VALBELOB defined
> > NUMERIC(15,2) default 0.
> >
> > I contained the value INF
> >
> >
> > What does that mean ?
> INF means "Infinity". It is a "state" that can be stored
> (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