Data type Numeric

if there will not be decimal point you can use bigint datatype

HTH

On Fri, 13 Sep 2002, 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)??

Thanks!
Carmen

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Darren Ferguson

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@Yahoo.com #