X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A8654D1B7F0 for ; Fri, 30 Jan 2004 20:30:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 95706-08 for ; Fri, 30 Jan 2004 16:30:10 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 7F7F9D1B447 for ; Fri, 30 Jan 2004 16:30:07 -0400 (AST) Received: (qmail 26639 invoked by uid 500); 30 Jan 2004 20:31:22 -0000 Date: Fri, 30 Jan 2004 14:31:22 -0600 From: Bruno Wolff III To: Chris Gamache Cc: pgsql-admin@postgresql.org Subject: Re: Alternative to "Money" ... Message-ID: <20040130203122.GA1488@wolff.to> Mail-Followup-To: Chris Gamache , pgsql-admin@postgresql.org References: <20040130185513.64147.qmail@web13810.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20040130185513.64147.qmail@web13810.mail.yahoo.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/304 X-Sequence-Number: 12167 On Fri, Jan 30, 2004 at 10:55:13 -0800, Chris Gamache wrote: > Well, after living with the (depreciated) Money datatype for 5 years, I think > its finally time to say goodbye (and now that we have DROP COLUMN it'll be MUCH > easier transition). What's the preferred monetary datatype? numeric(10,2)? > float4? float8? We're dealing only with US Dollars. You probably just want plain numeric.