From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | hamann(dot)w(at)t-online(dot)de, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: SQL help - multiple aggregates |
Date: | 2016-08-18 13:51:10 |
Message-ID: | CA+bJJbzhkRSc22Y7qrwBojiesMfiaDzE6OyhY_CqYK7+11mKwA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
CCing to the list ( if you are new to this list, messages come from
the sender address, you have to use "reply all" ( at least in my MUA,
web gmail ) to make your replies appear in the list ).
On Thu, Aug 18, 2016 at 3:03 PM, <hamann(dot)w(at)t-online(dot)de> wrote:
> Hi Francisco,
> thanks a lot. I will give it a try later
Do it, and do not forget to try the straightforward solution ( sume of
cases ) given by Ladislav Lenart above.I normally prefer to do this
kind of things the way I pointed you because the queries are simpler
and normally only the first one takes time, and using count tends to
be the faster way to extract the relevant data ( the rest of my query,
after the first with, is just moving data around for pretty-printing (
or pretty-selecting ).
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2016-08-18 14:02:28 | Re: Sequential vs. random values - number of pages in B-tree |
Previous Message | David G. Johnston | 2016-08-18 13:00:24 | Re: SQL help - multiple aggregates |