float4 problem
От
Oleg Bartunov
Тема
float4 problem
Дата
Msg-id
Pine.GSO.4.44.0211201836430.15576-100000@ra.sai.msu.su
Список
Дерево обсуждения
float4 problem Oleg Bartunov <oleg@sai.msu.su>
May be I miss something, but seems there is a problem with float4 in 7.2.3 and 7.3RC1 (6.53 works fine): test=# create table t ( a float4); CREATE TABLE test=# insert into t values (0.1); INSERT 32789 1 test=# select * from t where a=0.1;a --- (0 rows) test=# select * from t where a=0.1::float4; a -----0.1 (1 row) No problem with float8 test=# create table t8 ( a float8); CREATE TABLE test=# insert into t8 values (0.1); INSERT 32792 1 test=# select * from t8 where a=0.1; a -----0.1 (1 row) Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-hackers по дате отправления