On Thu, 11 Mar 2004, Neil Conway wrote: > So, what is the correct behavior: if you multiply two values and get a > result that exceeds the range of a float8, should you get > 'Infinity'/'-Infinity', or an overflow error?
That's the issue and I think we should allow infinity as a result of a float operation (like you got in the example). It's part of IEEE 754 math, so not getting Infinity as a result would break that. If someone does not want infinity stored in a column he/she could add a constraint to disallow it. -- /Dennis Björklund ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
