Re: double precision to numeric overflow error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thomas O'Connell" <tfo(at)monsterlabs(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: double precision to numeric overflow error
Date: 2003-01-08 04:15:09
Message-ID: 726.1041999309@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

"Thomas O'Connell" <tfo(at)monsterlabs(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-08 04:28:52 Re: shared buffers in config
Previous Message Tom Lane 2003-01-08 04:07:35 Re: [GENERAL] I feel the need for speed. What am I doing wrong?

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas O'Connell 2003-01-08 05:36:12 Re: double precision to numeric overflow error
Previous Message Thomas O'Connell 2003-01-08 03:01:09 Re: double precision to numeric overflow error