Re: Debet-Credit-Balance Calculation

From: "Muhyiddin A(dot)M Hayat" <middink(at)indo(dot)net(dot)id>
To: "Christopher Browne" <cbbrowne(at)acm(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Debet-Credit-Balance Calculation
Date: 2005-04-20 12:55:33
Message-ID: 005001c545a8$71b66bd0$1f00a8c0@middinks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> There is an easy way to do this; write a plpgsql set returning
> function which adds the balance to the last column of the table. That
> query will always have a cost in both time and memory proportional to
> the size of the table, and the memory cost may bite you as table size
> grows...
> --

Can you give me some example function which adds the balance to the last
column of the table. or other query which same result and more faster

Thanks.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Browne 2005-04-20 13:43:05 Re: Debet-Credit-Balance Calculation
Previous Message Muhyiddin A.M Hayat 2005-04-20 12:50:48 Re: Debet-Credit-Balance Calculation