Window functions frame_exclusion

Hello All, PostgreSQL supports "frame exclusion" in window function, e.g.: "SELECT sum(x) OVER (PARTITION BY y ORDER BY z ROWS BETWEEN UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING EXCLUDE CURRENT ROW) from t", (you can see here

Re: Window functions frame_exclusion

It would be good to have this as a feature. Are you proposing to fully implement the feature (I.e. add to parser, validator, and Enumerable convention, so that we can execute such queries) or just add it to the parser? I think our users might be confused or frustrated if the parser supports the

Re: Window functions frame_exclusion

Sure, I can do that. I will probably need some help with the Enumerable code though because I'm not familiar with it. I've created a ticket for it: https://issues.apache.org/jira/browse/CALCITE-5855 On Mon, Jul 17, 2023 at 7:43 AM Julian Hyde wrote: > It would be good to have this as a feature.