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