From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Single Table Report With Calculated Column |
Date: | 2014-08-29 16:50:22 |
Message-ID: | alpine.LNX.2.11.1408290946390.9118@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 29 Aug 2014, David G Johnston wrote:
> You want to use window clause/function.
David,
I read about this, but did not absorb everything.
> Add the following to the first query, in the select-list:
> Sum(count(*)) over (partition by stream, sampdate) as stream_date_total
> You function counts can then be divided into this.
> The count(*) is because of the outer group by
> The sum(...) is the window function
So this is a way of combinging aggregates; I tried something like the
above but postfix did not like my syntax; it was not using partitions.
> You could also just put both your queries into a with/cte (2 items) and do a
> normal inner join...
>
> Or
>
> Select ... From (first query) fq join (second query) sq on (...)
Both of which need more study on my part. I read about CTEs and did not
then see how to apply them to my needs.
Many thanks,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-08-29 17:03:49 | Re: Single Table Report With Calculated Column |
Previous Message | Steve Crawford | 2014-08-29 16:09:11 | Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions |