Re: [GENERAL] Casting numeric values to double

2005-10-04 Thread Daniel Schregenberger
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

[GENERAL] Casting numeric values to double

2005-10-03 Thread Daniel Schregenberger
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

Re: [GENERAL] Casting numeric values to double

2005-10-03 Thread Tom Lane
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

Re: [GENERAL] Casting numeric values to double

2005-10-03 Thread Martijn van Oosterhout
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