From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Zot O'Connor" <zot(at)zotconsulting(dot)com> |
Cc: | postgres sql <pgsql-sql(at)hub(dot)org> |
Subject: | Re: [SQL] Decimal precsion? |
Date: | 1999-10-30 00:01:09 |
Message-ID: | 199910300001.UAA24534@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
>
> create table subzone (
> subzid integer,
> subzsid integer DEFAULT NEXTVAL ('subzone_seq'),
> subzdescr varchar,
> subztaxper decimal(0,4),
> subzvendid integer,
> subzwhsid integer,
> subztaxship integer
> );
> ERROR: DECIMAL precision 0 must be beween 1 and 1000
>
>
> Is this documented anywhere? By the way it should be "beTween."
Precision is the full length of the field. Scale is the number of
digits to the right of the decimal point.
Beween -> Between change made.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-10-30 00:19:26 | Re: [SQL] trivial problem |
Previous Message | Tom Lane | 1999-10-29 23:37:49 | Re: [SQL] trivial problem |