Re: Two Window aggregate node for logically same over clause

2023-10-09 Thread "Anitha S"

Re: Two Window aggregate node for logically same over clause

2023-10-06 Thread Tom Lane
Ashutosh Bapat writes: > On Thu, Oct 5, 2023 at 8:53 PM "Anitha S" wrote: >> We have observed that for logically same over clause two different window >> aggregate nodes are created in plan. >> The below query contains two window functions. Both Over clause contain the >> same partition &

Re: Two Window aggregate node for logically same over clause

2023-10-06 Thread Ashutosh Bapat
On Thu, Oct 5, 2023 at 8:53 PM "Anitha S" wrote: > > > > Hi team, > > We have observed that for logically same over clause two different > window aggregate nodes are created in plan. > The below query contains two window functions. Both Over clause contain the > same partition & order

Two Window aggregate node for logically same over clause

2023-10-05 Thread "Anitha S"
Hi team,       We have observed that for logically same over clause two different window aggregate nodes are created in plan.   The below query contains two window functions. Both Over clause contain the same partition & order clause in it. But in one over clause ordering option is mentioned