Обсуждение: 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 #