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 758C8D1C46E for ; Fri, 30 Jan 2004 18:55:13 +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 57533-10 for ; Fri, 30 Jan 2004 14:55:14 -0400 (AST) Received: from web13810.mail.yahoo.com (web13810.mail.yahoo.com [216.136.175.218]) by svr1.postgresql.org (Postfix) with SMTP id D660DD1BC68 for ; Fri, 30 Jan 2004 14:55:12 -0400 (AST) Message-ID: <20040130185513.64147.qmail@web13810.mail.yahoo.com> Received: from [216.173.173.66] by web13810.mail.yahoo.com via HTTP; Fri, 30 Jan 2004 10:55:13 PST Date: Fri, 30 Jan 2004 10:55:13 -0800 (PST) From: Chris Gamache Reply-To: cgg007@yahoo.com Subject: Alternative to "Money" ... To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/301 X-Sequence-Number: 12164 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. CG __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/