Home > mailing lists

Re: SQL help - multiple aggregates - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: SQL help - multiple aggregates
Date	August 18, 2016 16:00:32
Msg-id	CAKFQuwZ-+MzeaPb-EUfAa7OJY+noxyoESSP+XUgwf666ChPM7Q@mail.gmail.com Whole thread Raw
In response to	SQL help - multiple aggregates (hamann.w@t-online.de)
List	pgsql-general

Tree view

On Thu, Aug 18, 2016 at 4:56 AM, <hamann.w@t-online.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.

pgsql-general by date:

From: Ladislav Lenart
Date: 18 August 2016, 15:51:43
Subject: Re: SQL help - multiple aggregates

From: Francisco Olarte
Date: 18 August 2016, 16:51:59
Subject: Re: SQL help - multiple aggregates

Re: SQL help - multiple aggregates - Mailing list pgsql-general

Previous

Next