Received: from eater.zotnet.com (IDENT:root@snapuser87.pacificcrest.net [216.36.24.87]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA81838 for ; Fri, 29 Oct 1999 18:24:46 -0400 (EDT) (envelope-from zot@zotconsulting.com) Received: from zotconsulting.com (zot@mp.zotnet.com [216.36.24.118]) by eater.zotnet.com (8.8.7/8.8.7) with ESMTP id PAA07646 for ; Fri, 29 Oct 1999 15:44:32 -0700 Sender: zot@eater.zotnet.com Message-ID: <381A1EFC.47061275@zotconsulting.com> Date: Fri, 29 Oct 1999 15:26:04 -0700 From: "Zot O'Connor" Organization: Zot Consulting X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.5-15smp i686) X-Accept-Language: en MIME-Version: 1.0 To: postgres sql Subject: Decimal precsion? 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." -- Zot O'Connor www.ZotConsulting.com www.WhiteKnightHackers.com