[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; Una

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 &