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 TAA90682 for ; Fri, 29 Oct 1999 19:21:50 -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 QAA07712 for ; Fri, 29 Oct 1999 16:41:48 -0700 Sender: zot@eater.zotnet.com Message-ID: <381A2C66.1809CE9F@zotconsulting.com> Date: Fri, 29 Oct 1999 16:23:18 -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: Numeric Bug? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit It appears as though 0.0 has a bigger value? I am running redhar 6.5.2 rpms (RH6). DROP create table example( other decimal(4,4) ); CREATE insert into example (other) values(3.9); ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4 scale 4 insert into example (other) values(0.0); ERROR: overflow on numeric ABS(value) >= 10^0 for field with precision 4 scale 4 insert into example (other) values(0.1); INSERT 49645 1 insert into example (other) values(0.1234); INSERT 49710 1 I can insert 0.1 but not 0.0? This cannot be right! This works for Solid and mysql! Is there a workaround? -- Zot O'Connor www.ZotConsulting.com www.WhiteKnightHackers.com