SELECT with REAL... - Mailing list pgsql-general

From Philippe Ferreira
Subject SELECT with REAL...
Date
Msg-id 43E67C6F.2080302@worldonline.fr
Whole thread Raw
Responses Re: SELECT with REAL...  (Michael Glaesemann <grzm@myrealbox.com>)
Re: SELECT with REAL...  (Steve Atkins <steve@blighty.com>)
List pgsql-general
Hi,

I've never noticed before, but I don't manage to do a "SELECT" with
conditions on REAL columns !!

For example, the following command always returns 0 row, even if rows
with myreal=10.5 do exist :
     SELECT * FROM mytable WHERE myreal=10.5;

Where am I wrong ?!

Thank you in advance,
Philippe Ferreira.

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: logging settings
Next
From: "John Tulodziecki"
Date:
Subject: Array of Composite Type as Stored Procedure parameter.