select real returns nothing
| От | Chris Sutton |
|---|---|
| Тема | select real returns nothing |
| Дата | |
| Msg-id | Pine.LNX.4.33.0206121434200.19119-100000@zev.ifloor.com обсуждение исходный текст |
| Список | pgsql-bugs |
I'm getting some weird things happen when trying to search for a specific row in a table that contains "real" types.
Here is my table structure
table units (
unit_id int4,
price_unit varchar(10),
unit_cov real,
unit_wt real);
The following row exists in the units table
unit_id | price_unit | unit_cov | unit_wt
---------+------------+----------+---------
47430 | LF | 12 | 4.833
The following query returns no rows:
SELECT unit_id FROM units
WHERE price_unit='LF' and unit_cov=12 and unit_wt=4.833;
While these queries return the correct unit_id
SELECT unit_id FROM units
WHERE price_unit='LF' and unit_cov='12' and unit_wt='4.833';
SELECT unit_id FROM units
WHERE price_unit='LF' and unit_cov='12' and unit_wt=float4(4.833);
I'm running pg7.2.1 on Linux.
The curious thing is I have a development database running pg7.1 on linux where I don't have this problem.
В списке pgsql-bugs по дате отправления: