On Mon, 2005-10-03 at 17:44 +0200, Martijn van Oosterhout wrote:
On Mon, Oct 03, 2005 at 03:31:42PM +0200, Daniel Schregenberger wrote:
I recently stumbled uppon the following thing:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a
Hi,
I recently stumbled uppon the following thing:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a double precision value and the
comparison fails with the following message:
# SELECT * FROM tr_table_okpx WHERE prating = 3.6;
Unable to
Daniel Schregenberger [EMAIL PROTECTED] writes:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a double precision value and the
comparison fails with the following message:
# SELECT * FROM tr_table_okpx WHERE prating = 3.6;
Unable to
On Mon, Oct 03, 2005 at 03:31:42PM +0200, Daniel Schregenberger wrote:
Hi,
I recently stumbled uppon the following thing:
If I compare a field of type numeric to a small decimal constant like
3.6, the constant is interpreted as a double precision value and the
comparison fails with the