David W Noon wrote: > On Tue, 6 Oct 2009 12:20:11 +0600, Nurzhan Kirbassov wrote about > 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. Yes, this is confusing, but it is how the standard defines the behavior. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
