Changes between Initial Version and Version 3 of Ticket #29850
- Timestamp:
- Dec 27, 2018, 1:42:18 PM (5 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #29850
- Property Triage Stage Unreviewed → Accepted
- Property Summary Poor Window Support for RowRange Frames → Add window support for RowRange frames
- Property Type Uncategorized → New feature
- Property Version 2.1 → master
-
Ticket #29850 – Description
initial v3 10 10 ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING EXCLUDE CURRENT ROW 11 11 12 ---- 13 14 Frame exclusion is supported only in [https://www.postgresql.org/docs/11/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS PostgreSQL 11+], other databases do not support exclusion (see [https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Analytic-Functions.html#GUID-527832F7-63C0-4445-8C16-307FA5084056 Oracle 18c doc], [https://mariadb.com/kb/en/library/window-functions-overview/ MariaDB doc], and [https://dev.mysql.com/doc/refman/8.0/en/window-functions-frames.html MySQL doc]).