Re: Two Window aggregate node for logically same over clause

2023-10-09 Thread "Anitha S"
https://www.postgresql.org/docs/16/sql-select.html#SQL-ORDERBY:~:text=Optionally%20one%20can%20add%20the%20key%20word%20ASC%20(ascending)%20or%20DESC%20(descending)%20after%20any%20expression%20in%20the%20ORDER%20BY%20clause.%20If%20not%20specified%2C%20ASC%20is%20assumed%20by%20default.%20Alternat

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 & order

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 clau