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

Reply via email to