Re: [GENERAL] double precision to numeric overflow error - Mailing list pgsql-sql

From Tom Lane
Subject Re: [GENERAL] double precision to numeric overflow error
Date
Msg-id 726.1041999309@sss.pgh.pa.us
Whole thread Raw
In response to Re: double precision to numeric overflow error  (Thomas O'Connell <tfo@monsterlabs.com>)
List pgsql-sql
"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

pgsql-sql by date:

Previous
From: Thomas O'Connell
Date:
Subject: Re: double precision to numeric overflow error
Next
From: Thomas O'Connell
Date:
Subject: Re: double precision to numeric overflow error