float8 comparison failure

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Radek Kanovsky
Your email address : rk@dat.cz

System Configuration
---------------------
Architecture (example: Intel Pentium) : PC - AMD K6 3D

Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.16 (Debian)

PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.5.3
(6.5.1, 6.5.2)

Compiler used (example: gcc 2.8.0) : gcc 2.95.2
libc6 2.1.3

Please enter a FULL description of your problem:
------------------------------------------------

I have one table defined as follows

CREATE TABLE misto (
idm VARCHAR(8) NOT NULL PRIMARY KEY,
nazev VARCHAR(64) NOT NULL,
okres VARCHAR(2) NOT NULL,
sourad_s FLOAT,
sourad_d FLOAT,
modifikace DATETIME NOT NULL DEFAULT now(),
modifikoval VARCHAR(32) NOT NULL DEFAULT getpgusername()
) ;
CREATE INDEX misto_okres ON misto (okres);
CREATE INDEX misto_nazev ON misto (nazev);

These three SELECTs don't return same result:

SELECT idm,sourad_s,sourad_d FROM misto WHERE idm = 'MHO00179';
idm | sourad_s| sourad_d
--------+-------------+-------------
MHO00179|48.9247114069|17.6064515081
(1 row)

SELECT idm,sourad_s,sourad_d FROM misto WHERE sourad_s = 48.9247114069;
idm | sourad_s| sourad_d
--------+-------------+-------------
MHO00179|48.9247114069|17.6064515081
(1 row)

SELECT idm,sourad_s,sourad_d FROM misto WHERE sourad_d = 17.6064515081;
idm|sourad_s|sourad_d
---+--------+--------
(0 rows)

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

The problem appears randomly. I havent found any relation
with anything else. I often use Python interface for INSERT,
UPDATE, SELECT.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

This helps:

BEGIN;
UPDATE misto SET sourad_d = 17.6064515081 WHERE idm = 'MHO00179';
END;

SELECT idm,sourad_s,sourad_d FROM misto WHERE sourad_d = 17.6064515081;
idm | sourad_s| sourad_d
--------+-------------+-------------
MHO00179|48.9247114069|17.6064515081