From: | Robert Zenz <robert(dot)zenz(at)sibvisions(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Ways to deal with large amount of columns; |
Date: | 2018-08-30 13:15:07 |
Message-ID: | 5B87EDDF.60602@sibvisions.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
On 30.08.2018 11:13, a wrote:
> Hi all:
>
>
> I need to make a table contains projected monthly cashflow for multiple agents (10,000 around).
>
>
> Therefore, the column number would be 1000+.
>
>
> I would need to perform simple aggregate function such as count, sum or average on each cashflow projected.
>
>
> So if there is anyway of doing this? Will there be anything like define a macro in C that I can manipulate multiple columns by simple word that representing them.
>
>
> Thanks so much!
>
>
> Shore
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2018-08-30 13:27:51 | Re: Ways to deal with large amount of columns; |
Previous Message | Andreas Kretschmer | 2018-08-30 13:03:54 | Re: Ways to deal with large amount of columns; |