From: | "Francisco Figueiredo Jr(dot)" <fxjrlists(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Fields float4 don't return any row when selecting a value with a . |
Date: | 2003-06-18 02:26:07 |
Message-ID: | 3EEFCDBF.30402@yahoo.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi all,
I'm using the 7.4 cvs version on cygwin and I noticed that if I have a
table with a field of float4 type and try to do a simple select:
select * from table where field_float4 = 4.4
it doesn't return any rows.
In the same table I have a float8 field and it works ok.
If I try with a value without the . in the float4 field it also works.
The only way I could get the field_float4 to work was to add '' in the
value.
Summary of results:
Table created as: create table tableD(field_float4 float4, field_float8
float8);
insert into tableD values (3.3, 4.4);
insert into tableD values (4, 3);
select * from tableD where field_float4 = 3.3 ==> 0 rows returned
select * from tableD where field_float8 = 4.4 --> 1 row returned.
select * from tableD where field_float4 = '3.3' ==> 1 row returned.
Can someone confirm that for me?
Thanks in advance.
--
Regards,
Francisco Figueiredo Jr.
------
"My grandfather once told me that there are two
kinds of people: those
who work and those who take the credit. He told me
to try to be in the
first group; there was less competition there."
- Indira Gandhi
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-06-18 03:31:55 | Re: Fields float4 don't return any row when selecting a value with a . |
Previous Message | Christopher Kings-Lynne | 2003-06-18 01:39:54 | Re: pg_get_triggerdef in pg_dump |