On Thu, Aug 18, 2016 at 4:56 AM, <hamann(dot)w(at)t-online(dot)de> wrote:
> select custid, count(vendid) as c415 from cv where vendid = 415 group by
> custid
> [...]
>
> Is there a better way (by creating an aggregate function, perhaps)
>
You may find crosstab in the tablefuncs extension to be of use.
https://www.postgresql.org/docs/current/static/tablefunc.html
David J.