Re: [GENERAL] Query precision issue

2010-10-25 Thread DM
Hello Sairam, What is the type of the colum?, what version of postgres are you using? I didn't had any problem retrieving data in both ways... check out the below = test=# create temp table test (col1 float); CREATE TABLE test=# insert into test values

[GENERAL] Query precision issue

2010-10-25 Thread Sairam Krishnamurthy
All, I have simple query like 'select * from table1 where column1=-107.689878'. 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 tha