Thread: Data type Numeric

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

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 #