X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 57D119FCF16 for ; Mon, 28 Aug 2006 10:49:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 57812-07 for ; Mon, 28 Aug 2006 13:49:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from druid.net (druid.net [66.96.28.249]) by postgresql.org (Postfix) with ESMTP id 561619FCF03 for ; Mon, 28 Aug 2006 10:49:27 -0300 (ADT) Received: from dilbert.druid.net (H245.C18.B96.tor.eicat.ca [66.96.18.245]) by druid.net (Postfix) with SMTP id E88ACB560; Mon, 28 Aug 2006 09:49:21 -0400 (EDT) Date: Mon, 28 Aug 2006 09:49:30 -0400 From: "D'Arcy J.M. Cain" To: aarni@kymi.com Cc: mike@fuhr.org, pgsql-sql@postgresql.org Subject: Re: double precision vs. numeric Message-Id: <20060828094930.54291424.darcy@druid.net> In-Reply-To: <200608281632.31039.aarni@kymi.com> References: <200608241936.50752.aarni@kymi.com> <200608281108.50394.aarni@kymi.com> <20060828130827.GB4094@winnie.fuhr.org> <200608281632.31039.aarni@kymi.com> X-Mailer: Sylpheed version 2.2.0 (GTK+ 2.8.12; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200608/218 X-Sequence-Number: 26176 On Mon, 28 Aug 2006 16:32:31 +0300 Aarni Ruuhim=E4ki wrote: > > > So this merely means that in future one can not insert empty values i= nto > > > field of type double precision ? > > > > Right. 8.0 issues a warning and 8.1 gives an error: >=20 > But NULLs will go in the future too ? No, NULL has always been the correct way to insert a non-value into a field. Text/char type fields are the only ones where an empty string is a valid value. --=20 D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.