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 interpr

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 wi

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.