| From: | Darren Ferguson <darren(at)crystalballinc(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 15:47:59 |
| Message-ID: | Pine.LNX.4.44.0209131147390.16908-100000@thread.crystalballinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org
>
--
Darren Ferguson
| From | Date | Subject | |
|---|---|---|---|
| Next Message | frank_lupo | 2002-09-13 16:13:43 | postgres crash |
| Previous Message | Sathish Vadhiyar | 2002-09-13 15:39:23 | user defined data types - help |