Postgres Pro
Downloads
Home   >   mailing lists

Different exponent in error messages - Mailing list pgsql-general

From Andrus
Subject Different exponent in error messages
Date
Msg-id dq3qnv$jur$1@news.hub.org
Whole thread Raw
Responses Re: Different exponent in error messages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I have NUMERIC(9,3) field.
Postgres produces different (!) error messages when inserted value is too
big to fit into this field

ERROR:  numeric field overflow

DETAIL:  The absolute value is greater than or equal to 10^6 for field with
precision 9, scale 3.;

DETAIL:  The absolute value is greater than or equal to 10^9 for field with
precision 9, scale 3.;

DETAIL:  The absolute value is greater than or equal to 10^7 for field with
precision 9, scale 3.;


Why Postgres 8.1.1 in XP returns different exponents ( 10^6, 10^9, 10^7) for
field with precision 9, scale 3 ?

Andrus.

pgsql-general by date:

Previous
From: "Jim Nasby"
Date:
Subject: Re: [SPAM] - how can we use outer join in Postures - Found word(s) if you received this in error in the Text body
Next
From: "Qingqing Zhou"
Date:
Subject: Re: index and MVCC