Re: numeric field overflow - Mailing list pgsql-general

From David W Noon
Subject Re: numeric field overflow
Date
Msg-id 20091006110553.31272515@dwnoon.ntlworld.com
Whole thread Raw
In response to numeric field overflow  (Nurzhan Kirbassov <km.sameboy@gmail.com>)
Responses Re: numeric field overflow
List pgsql-general
On Tue, 6 Oct 2009 12:20:11 +0600, Nurzhan Kirbassov wrote about
[GENERAL] numeric field overflow:

[snip]
>So, does the precision part of the numeric type really means number of
>digits to the left of the decimal point, or what ?

No.

The precision is the *total* number of decimal digits, both to the left
and to the right of the decimal point.
--
Regards,

Dave  [RLU #314465]
=======================================================================
david.w.noon@ntlworld.com (David W Noon)
=======================================================================

pgsql-general by date:

Previous
From: Tim Bunce
Date:
Subject: Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5
Next
From: David Fetter
Date:
Subject: Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5