Query precision issue
| От | Sairam Krishnamurthy |
|---|---|
| Тема | Query precision issue |
| Дата | |
| Msg-id | 4CC5BA2F.8010202@gmail.com обсуждение исходный текст |
| Ответы |
Re: Query precision issue
|
| Список | pgsql-general |
All,
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.
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.
-- Thanks, Sairam Krishnamurthy +1 612 859 8161
В списке pgsql-general по дате отправления: