pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: D'Arcy J.M. Cain <darcy@druid.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: aspire420@hotpop.com
Cc: Wei Weng <wweng@kencast.com>
Cc: Martin Marques <martin@bugs.unl.edu.ar>
Cc: pgsql-sql@postgresql.org
Subject: Re: Anti log in PostgreSQL
Date: Sat, 27 Dec 2003 05:40:52 -0500
Message-ID: <200312270540.52321.darcy@druid.net> (raw)
In-Reply-To: <8203.1072481860@sss.pgh.pa.us>
References: <3FECB238.1050801@sancharnet.in>
	<3FECC357.6040206@sancharnet.in>
	<8203.1072481860@sss.pgh.pa.us>

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 <darcy@{druid|vex}.net>   |  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.



view thread (12+ messages)

Message-ID: <200312270540.52321.darcy@druid.net>
Permalink:  ../200312270540.52321.darcy@druid.net/
Also on:    postgresql.org/message-id/200312270540.52321.darcy@druid.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: darcy@druid.net, tgl@sss.pgh.pa.us, aspire420@hotpop.com, wweng@kencast.com, martin@bugs.unl.edu.ar
  Subject: Re: Anti log in PostgreSQL
  In-Reply-To: <200312270540.52321.darcy@druid.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox