Tom Lane wrote: > Roman Kononov <[EMAIL PROTECTED]> writes: > > On 12/27/2006 03:23 PM, Bruce Momjian wrote: > >> Are you sure? As I remember, computation automatically upgrades to > >> 'double'. See this program and output: > > > This is platform- and compiler- dependent: > > ... and probably irrelevant, too. We should store the result into a > float4 variable and then test for isinf() on that; that eliminates the > question of whether the compiler did the multiply in a wider format or > not.
True for overflow to Infinity, but underflow checking is better for float4 using float8. See previous email for details. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
