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 UAA99621 for ; Fri, 29 Oct 1999 20:31:24 -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 UAA25626; Fri, 29 Oct 1999 20:30:48 -0400 (EDT) From: Bruce Momjian Message-Id: <199910300030.UAA25626@candle.pha.pa.us> Subject: Re: [SQL] Decimal precsion? In-Reply-To: <381A36FB.643E7901@zotconsulting.com> from "Zot O'Connor" at "Oct 29, 1999 05:08:27 pm" To: "Zot O'Connor" Date: Fri, 29 Oct 1999 20:30:48 -0400 (EDT) CC: PostgreSQL-SQL , Jan Wieck X-Mailer: ELM [version 2.4ME+ PL65 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > > Yeah I finnally figured that out, wish the docs would cover things like > that. > > I went through two books (which said its just liek COBOL! and then > ignored me) and finnally the mysql pages had a good right up. > > I still thing the 0.0 thing is an error. > Yes, and why doesn't this generate an error: test=> insert into example values(0.12345); INSERT 19488 1 test=> insert into example values(0.1234567); INSERT 19489 1 test=> select * from example; other ------ 0.1235 0.1235 (2 rows) Jan, can you comment on this. I found the code in numeric.c, but can't figure out what the proper test should be. -- 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