Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA95982 for ; Fri, 29 Oct 1999 20:02:03 -0400 (EDT) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id UAA24534; Fri, 29 Oct 1999 20:01:09 -0400 (EDT) From: Bruce Momjian Message-Id: <199910300001.UAA24534@candle.pha.pa.us> Subject: Re: [SQL] Decimal precsion? In-Reply-To: <381A1EFC.47061275@zotconsulting.com> from "Zot O'Connor" at "Oct 29, 1999 03:26:04 pm" To: "Zot O'Connor" Date: Fri, 29 Oct 1999 20:01:09 -0400 (EDT) CC: postgres sql X-Mailer: ELM [version 2.4ME+ PL65 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > 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@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026