Message-ID: <ec8b2c82-a74b-6bc5-c543-68a98afb8b11@gmail.com>
Date: Sun, 27 Nov 2022 22:24:51 +0530
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: [QUESTION] Window function with partition by and order by
Content-Language: en-US
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@lists.postgresql.org
References: <7f9f9b1d-b612-d0bd-4674-cfb5a8b2d343@gmail.com>
 <355604.1669566484@sss.pgh.pa.us>
From: Ankit Kumar Pandey <itsankitkp@gmail.com>
In-Reply-To: <355604.1669566484@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/ec8b2c82-a74b-6bc5-c543-68a98afb8b11%40gmail.com>
Precedence: bulk


On 27/11/22 21:58, Tom Lane wrote:
> Ankit Kumar Pandey <itsankitkp@gmail.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