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.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster