From: Chris Browne <cbbrowne@acm.org>
To: pgsql-sql@postgresql.org
Subject: Re: Debet-Credit-Balance Calculation
Date: Wed, 20 Apr 2005 09:43:05 -0400
Message-ID: <60ll7d36om.fsf@dba2.int.libertyrms.com> (raw)
References: <001c01c544ff$bb94d650$1f00a8c0@middinks>
<m3vf6iw35p.fsf@knuth.cbbrowne.com>
<003f01c545a7$b7e3c5e0$1f00a8c0@middinks>
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/;
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: cbbrowne@acm.org
Subject: Re: Debet-Credit-Balance Calculation
In-Reply-To: <60ll7d36om.fsf@dba2.int.libertyrms.com>
* 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