Re: numeric field overflow

From: David W Noon <dwnoon(at)ntlworld(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: numeric field overflow
Date: 2009-10-06 10:05:53
Message-ID: 20091006110553.31272515@dwnoon.ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)w(dot)noon(at)ntlworld(dot)com (David W Noon)
=======================================================================

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-10-06 11:44:46 Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5
Previous Message Tim Bunce 2009-10-06 08:57:39 Re: Wishlist of PL/Perl Enhancements for PostgreSQL 8.5