Re: double precision to numeric overflow error
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Thomas O'Connell" <tfo@monsterlabs.com>
Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Date: 2003-01-08T04:15:09Z
Lists: pgsql-general
"Thomas O'Connell" <tfo@monsterlabs.com> 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 precision > 15 scale 6 It's technically correct, but if you think you can word it better, let's see your proposal... regards, tom lane