db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew ``Bass'' Shcheglov" <andrewb...@gmail.com>
Subject Re: Double.NaN in table?
Date Wed, 19 Dec 2007 09:04:39 GMT
> Microsoft's SQL Server doesn't allow any of the special values in
> float/double fields. (i.e. positive/negative infinity or NaN). It is
> very annoying.

If +INF/-INF are to be stored along with NaNs,
and the database server (Derby in our case) doesn't allow it directly,
I don't see how one can accomplish this w/o introducing an extra column
(of type TINYINT, for instance) which would store a boolean flag
to tell you whether your double value is a regular or a special one.

Andrew ``Bass'' Shcheglov

View raw message