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 5BF819FB25B for ; Thu, 24 Aug 2006 13:37:15 -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 79145-01 for ; Thu, 24 Aug 2006 16:36:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 6CC4F9FB24D for ; Thu, 24 Aug 2006 13:36:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from smtp20.kymp.net (smtp20.kymp.net [80.248.96.137]) by svr4.postgresql.org (Postfix) with ESMTP id 5B5555AF884 for ; Thu, 24 Aug 2006 16:36:55 +0000 (GMT) Received: from [192.168.0.100] (static-241-66.kymp.net [213.130.241.66]) by smtp20.kymp.net (8.13.3/8.13.3) with SMTP id k7OGap2L003982 for ; Thu, 24 Aug 2006 19:36:51 +0300 From: Aarni =?iso-8859-1?q?Ruuhim=E4ki?= Reply-To: aarni@kymi.com Organization: KYMI.com To: Subject: double precision vs. numeric Date: Thu, 24 Aug 2006 19:36:50 +0300 User-Agent: KMail/1.6.2 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <200608241936.50752.aarni@kymi.com> X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.816 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200608/179 X-Sequence-Number: 26137 Hello, Not sure if this is the right list to ask ... I vaguely remember having seen a message=20 ' ... type double precision ... will be depreciated / unsupported in future= =20 releases ... ' or something like that somewhere. (?) I have quite a few older dbs with tables that have one or more fields type= =20 double precision and have so far upgraded ok since 7.0.x (I now use numeric= =20 with appropriate precision and scale.) Is there something to worry about when upgrading next time ? Start changing= =20 these to numeric perhaps ? Running 8.0.2 at the moment. Best regards to all, Aarni =2D-=20 Aarni Ruuhim=E4ki **Kmail** **Fedora Core Linux**