Postgres Average Weighted

Asked Jun 30 '16 at 03:57

Active Jun 30 '16 at 03:57

Viewed 132 times

I looked up several finding average weight questions posted in SO but none quite match my requirement.

This is what is expected.

The Postgres table stores the following fields.

Taking a reference from the screenshot above, I need to know what is the function or query I need to create in Postgres so that when an entry is inserted in between 02-Jun-16 and 23-Jun-16, the table will recompute all the relevant value and update the 3 columns G, H, I.

asked Jun 30 '16 at 03:57

Christopher Lim

Someone suggested to use recursive CTE in this post, http://stackoverflow.com/questions/22426878/calculating-the-weighted-average-cost-of-products-stock – Christopher Lim Jun 30 '16 at 04:04
In CTE, I cannot perform update. So how else I can I do it efficiently? – Christopher Lim Jun 30 '16 at 04:06

Postgres Average Weighted

0 Answers0