Re: Debet-Credit-Balance Calculation - Mailing list pgsql-sql

From Chris Browne
Subject Re: Debet-Credit-Balance Calculation
Date
Msg-id 60ll7d36om.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to Debet-Credit-Balance Calculation  ("Muhyiddin A.M Hayat" <middink@indo.net.id>)
List pgsql-sql
middink@indo.net.id ("Muhyiddin A.M Hayat") writes:
>> 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.
>
> Thanks.

No time, but here is a link to a useful article on SRFs.

<http://techdocs.postgresql.org/guides/SetReturningFunctions>

Once you know how to do an SRF, you should be able to build the one
you need.
-- 
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www.ntlug.org/~cbbrowne/sap.html
Rules of the Evil Overlord #78.  "I will not tell my Legions of Terror
"And he must  be taken alive!" The command will be:  ``And try to take
him alive if it is reasonably practical.''"
<http://www.eviloverlord.com/>


pgsql-sql by date:

Previous
From: "Muhyiddin A.M Hayat"
Date:
Subject: Re: Debet-Credit-Balance Calculation
Next
From: Marinos Yannikos
Date:
Subject: Odd error message (" hash indexes do not support whole-index scans")