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
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