| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | e-letter <inpost(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: e: Running/cumulative count using windows |
| Date: | 2013-09-13 15:01:17 |
| Message-ID: | CAHyXU0zig--xzfPjDFYuYANuRz2oVAtTZ-nX6yqx773=cvt0Ag@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 13, 2013 at 8:18 AM, e-letter <inpost(at)gmail(dot)com> wrote:
>> test=*# select extract (year from signup_date)::text || '/' ||
> extract(month from signup_date)::text, count(email_address),
> sum(count(email_address)) over (ROWS UNBOUNDED PRECEDING) from test
> group by 1 order by 1;
>
> Have searched the manual and been unable to find reference to the
> commands 'unbounded' and 'preceding'; can someone please advise where
> to read about these commands?
http://www.postgresql.org/docs/9.1/static/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2013-09-13 15:08:43 | Re: Best way to populate nested composite type from JSON` |
| Previous Message | Merlin Moncure | 2013-09-13 14:58:51 | Re: Best way to populate nested composite type from JSON` |