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