float4 problem
| От | Oleg Bartunov |
|---|---|
| Тема | float4 problem |
| Дата | |
| Msg-id | Pine.GSO.4.44.0211201836430.15576-100000@ra.sai.msu.su обсуждение исходный текст |
| Список | pgsql-hackers |
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 по дате отправления: