Re: Data type Numeric - Mailing list pgsql-general

From Darren Ferguson
Subject Re: Data type Numeric
Date
Msg-id Pine.LNX.4.44.0209131147390.16908-100000@thread.crystalballinc.com
Whole thread Raw
In response to Data type Numeric  ("Carmen Wai" <wai_carmen@hotmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Sathish Vadhiyar
Date:
Subject: user defined data types - help
Next
From: "frank_lupo"
Date:
Subject: postgres crash