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 <[email protected]> wrote: > 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 syntax but we cannot execute it. > > Julian > > > On Jul 16, 2023, at 10:35 AM, Itiel Sadeh <[email protected]> > wrote: > > > > 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 > > < > https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS > >) > > which let you ignore some rows from the selected scope. > > Calcite however does not support it. > > Can I add it to the parser? Do we use conformance for such cases or other > > mechanisms? > > > > Thanks, > > Itiel >
