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 171FCD1D53B for ; Mon, 2 Feb 2004 17:00:39 +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 87399-02 for ; Mon, 2 Feb 2004 13:00:31 -0400 (AST) Received: from main.gmane.org (main.gmane.org [80.91.224.249]) by svr1.postgresql.org (Postfix) with ESMTP id 636C5D1D2E4 for ; Mon, 2 Feb 2004 13:00:30 -0400 (AST) Received: from root by main.gmane.org with local (Exim 3.35 #1 (Debian)) id 1AnhQt-000862-00 for ; Mon, 02 Feb 2004 18:00:23 +0100 Received: from srv.protecting.net ([212.126.218.242]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon Feb 2 17:00:23 2004 Received: from hf118 by srv.protecting.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon Feb 2 17:00:23 2004 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Harald Fuchs Subject: Re: Alternative to "Money" ... Date: 02 Feb 2004 17:50:47 +0100 Organization: Linux Private Site Lines: 14 Message-ID: References: <20040130185513.64147.qmail@web13810.mail.yahoo.com> <20040130203122.GA1488@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: srv.protecting.net X-No-Archive: yes User-Agent: Gnus/5.0808 (Gnus v5.8.8) Emacs/20.7 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/13 X-Sequence-Number: 12187 In article <20040130203122.GA1488@wolff.to>, Bruno Wolff III writes: > 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. As long as you don't want to deal with the new US budget deficit, storing cents in an INT or BIGINT column might perform better.