From: | e-letter <inpost(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | e: Running/cumulative count using windows |
Date: | 2013-09-13 13:18:52 |
Message-ID: | CAET1fe6fk99yJyROd3ZzC7AEdZwux5aXOGh7Qm8-qWMD83-mfg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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?
On 12/09/2013, pgsql-general-owner(at)postgresql(dot)org
<pgsql-general-owner(at)postgresql(dot)org> wrote:
> Message Digest
> Volume 1 : Issue 12450 : "mime" Format
>
> Messages in this Issue:
> Danger of renaming an enum label?
> Re: Major upgrade of PostgreSQL and MySQL
> Re: Call for design: PostgreSQL mugs
> Re: Call for design: PostgreSQL mugs
> problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
> Re: problem with query
>
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2013-09-13 13:37:08 | Re: Best way to populate nested composite type from JSON` |
Previous Message | Stephen Frost | 2013-09-13 13:04:24 | Re: Major upgrade of PostgreSQL and MySQL |