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 2133BD1D841 for ; Tue, 3 Feb 2004 14:42:49 +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 51743-04 for ; Tue, 3 Feb 2004 10:42:47 -0400 (AST) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id AEB8ED1D313 for ; Tue, 3 Feb 2004 10:42:44 -0400 (AST) Received: from solent (82-68-95-1.dsl.in-addr.zen.co.uk [82.68.95.1]) by bayswater1.ymogen.net (Postfix) with ESMTP id 664B69AD7C; Tue, 3 Feb 2004 14:42:47 +0000 (GMT) From: "Matt Clark" To: , "Harald Fuchs" , Subject: Re: Alternative to "Money" ... Date: Tue, 3 Feb 2004 14:42:40 -0000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) In-Reply-To: <20040203141733.80158.qmail@web13805.mail.yahoo.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/25 X-Sequence-Number: 12199 > .. I can't _quite_ tell if you're serious or not ... :) > > If you are serious, are you saying to do something like: > > CREATE TABLE new_money (product text, dollars int4, cents int4); Ha :-) That would not be serious. I'm pretty sure he meant to just store the product cost in cents instead of dollars, e.g. > CREATE TABLE new_money (product text, cents int4); > INSERT INTO new_money (product, cents) values ('Flowbee','1995'); > INSERT INTO new_money (product, cents) values ('Garth Brooks\'s > Greatest Hits','999'); M