Re: [SQL] [GENERAL] double precision to numeric overflow error

2003-01-17 Thread Jan Wieck
Thomas O'Connell wrote: > > Well, it would've immediately (rather than the several minutes it took) > given away the problem if it read something like: > > ERROR: overflow caused by cast of double precision value to numeric > without sufficient precision, scale (15, 6) > > or even, depending on

Re: [SQL] [GENERAL] double precision to numeric overflow error

2003-01-07 Thread Tom Lane
"Thomas O'Connell" <[EMAIL PROTECTED]> writes: > Indeed, it seems as though my inability to count digits was the real > problem. Still, does this not strike anyone as a somewhat abstruse error > message? How would you phrase it? > ERROR: overflow on numeric ABS(value) >= 10^9 for field with pr