Onfly Query - cumulative sum the stock change values by articles
От | Durumdara |
---|---|
Тема | Onfly Query - cumulative sum the stock change values by articles |
Дата | |
Msg-id | CAEcMXhm8oakWjW_KOZAbhvp=Hryx=PmJcz6JxQ242afund7maQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Onfly Query - cumulative sum the stock change values by articles
|
Список | pgsql-general |
Hello!
I have a query where I can show the positive and negative future changes of the articles.
For example:
from change left join art on art.id = change.art_id
Ok, I have a list of the changes.
I need to sum these changes to get the rows where the stock is negative or below the minimum.
1, bla, 100, 20, +20, 2021-02-01, [120]
1, bla, 100, 20, -10, 2021-02-01, [110]
1, bla, 100, 20, -100, 2021-02-01, [10] - below minimum
1, bla, 100, 20, -20, 2021-02-01, [-10] - below zero
2, bli, 20, 10, 10, 2021-02-01, [20]
2, bli, 20, 10, -15, 2021-02-01, [5] below minimum
How do I use a window function (can I use it) to "reset" the stock in every first record of the articles - to cumulate the data?
Or do I need to store data in a temporary table and use stored procedure to fill up the cumulated stock value?
Thank you for the answer!
Thank you for the answer!
Best regards
ddd
В списке pgsql-general по дате отправления: