Re: Data type Numeric

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Carmen Wai <wai_carmen(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data type Numeric
Date: 2002-09-13 17:58:31
Message-ID: 3D822747.AE735ED9@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Carmen Wai wrote:
>
> Hello:
>
> I am using Postgresql 7.2.1 and I found that when I set the column to
> numeric(10). It is limited to 9 digits only (e.g. 888888888). How can I set
> if I want to size to be with 10 digits (other than using float8)??

Works for me.

So what is the exact error message you're getting and could you
post a complete, self contained example that reproduces the
error?

Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being
right. #
# Let's break this rule - forgive
me. #
#==================================================
JanWieck(at)Yahoo(dot)com #

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2002-09-13 18:22:31 bigint datatype accepting floating numbers
Previous Message Williams, Travis L, NPONS 2002-09-13 17:47:46 Can't run configure