Re: Java boundary seems to violate Oracle's constraints.

On 18 Jun 2004, groups_at_karsten-schmidt.com wrote:
> Hi, don't think this violates any constraints and such. I did
> not check the actual bits you put in there, but it looks like
> you are hitting one of the 'magic' values that an Ieee float
> can take. in your case, looks like negative infinity.
>
> Perfectly valid number, mathematically speaking, just that you
> can
> not do any sensible computations with it.
>

Do you know how to do a comparison and find that this field is set to this value? It is definitely a data issue to us, and I have an algorithm we will use based on how it originates, but I'm not sure how to find it with a full-proof Oracle operator.

    SELECT blah
    FROM t1
    WHERE fld = ???
OR

    SELECT blah
    FROM t1
    WHERE fld < ???

-- 
Galen Boyer