Am 30.08.2018 um 15:15 schrieb Robert Zenz:
As David said, you'd be better off having a table that looks like this (in terms
of columns):
* MONTH
* AGENT
* CASHFLOW
So your query to get the sum of a single agent would be looking like:
select
sum(CHASFLOW)
where
AGENT = 'Agent'
and MONTH between values;
It might be a little more work to create a GUI for that (or map this model to
the existing GUI) but it is much simpler to maintain and work with.
agree. it is also possible to use partitioning.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
