Thats because float columns store approximate data values, you may need
to use an error range in comparison, or at your own discretion use the
decimal data type.
You can get more info in:
On 10/25/2010 12:15 PM, Sairam Krishnamurthy wrote:
> I have simple query like 'select * from table1 where
> column1=-107.6898780000'. This returns an empty set. But there is data
> corresponding to this value of column.
> When I looked more into it, it seems like a precision issue. The value
> for column1 is -107.689878.
> More interesting is that the following query fetches the row,
> 'select * from table1 where column1=-107.689878000'
> Note that there are only three trailing zeros in the second query
> while there were four in the first.
> Can somebody help me to find out the problem? I can very well truncate
> the trailing zeros when querying, but I am interested in finding why
> an additional trailing zero returns an empty set.