X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2FA7AD1B44A for ; Sat, 27 Dec 2003 10:41:45 +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 27037-10 for ; Sat, 27 Dec 2003 06:40:58 -0400 (AST) Received: from druid.net (druid.net [216.126.72.98]) by svr1.postgresql.org (Postfix) with ESMTP id D41A4D1B440 for ; Sat, 27 Dec 2003 06:40:55 -0400 (AST) Received: by druid.net (Postfix, from userid 1000) id AA24A1A80; Sat, 27 Dec 2003 05:40:53 -0500 (EST) From: "D'Arcy J.M. Cain" To: Tom Lane , aspire420@hotpop.com Subject: Re: Anti log in PostgreSQL Date: Sat, 27 Dec 2003 05:40:52 -0500 User-Agent: KMail/1.5.2 Cc: Wei Weng , Martin Marques , pgsql-sql@postgresql.org References: <3FECB238.1050801@sancharnet.in> <3FECC357.6040206@sancharnet.in> <8203.1072481860@sss.pgh.pa.us> In-Reply-To: <8203.1072481860@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200312270540.52321.darcy@druid.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/200 X-Sequence-Number: 16366 On December 26, 2003 06:37 pm, Tom Lane wrote: > accumulated roundoff in the monetary amounts. I think you will > need to write a little function (in plpgsql or your language of > choice) that performs the sequence of compounding steps, if you > want to get an answer that a banker will like. And make sure that you check your local rules. Mortgages are actually calculated differently in Canada and the US. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.