| From: | Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: [QUESTION] Window function with partition by and order by |
| Date: | 2022-11-27 16:54:51 |
| Message-ID: | ec8b2c82-a74b-6bc5-c543-68a98afb8b11@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On 27/11/22 21:58, Tom Lane wrote:
> Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> writes:
>> Question is: Average of id for partition name (A) should be 6/4 = 1.5
>> for all rows in that partition but this result is seen only at the last
>> one row in partition (A). Am I missing here something?
> https://www.postgresql.org/docs/current/tutorial-window.html
>
> particularly:
>
> By default, if ORDER BY is supplied then the frame consists of all
> rows from the start of the partition up through the current row, plus
> any following rows that are equal to the current row according to the
> ORDER BY clause.
>
> regards, tom lane
Thanks, I understand the behavior now.
--
Regards,
Ankit Kumar Pandey
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ankit Kumar Pandey | 2022-11-27 16:54:58 | Re: [QUESTION] Window function with partition by and order by |
| Previous Message | Tom Lane | 2022-11-27 16:28:04 | Re: [QUESTION] Window function with partition by and order by |