summaryrefslogtreecommitdiff
path: root/src/test/regress/sql/window.sql
AgeCommit message (Expand)Author
2025-10-08Make truncate_useless_pathkeys() consider WindowFuncsDavid Rowley
2025-10-03Add IGNORE NULLS/RESPECT NULLS option to Window functions.Tatsuo Ishii
2024-12-09Fix possible crash during WindowAgg evaluationDavid Rowley
2024-05-05Fix query pullup issue with WindowClause runConditionDavid Rowley
2024-01-10Handle WindowClause.runCondition in tree walker/mutator functions.Tom Lane
2023-11-14Support +/- infinity in the interval data type.Dean Rasheed
2023-08-04Attempt to stabilize new window agg regression testDavid Rowley
2023-08-03Account for startup rows when costing WindowAggsDavid Rowley
2023-03-17Fix incorrect logic for determining safe WindowAgg run conditionsDavid Rowley
2023-01-27Teach planner about more monotonic window functionsDavid Rowley
2023-01-07Add additional regression tests for select_active_windowsDavid Rowley
2022-12-24Fix recent accidental omission in pg_proc.datDavid Rowley
2022-12-22Allow window functions to adjust their frameOptionsDavid Rowley
2022-10-06Remove uses of MemoryContextContains in nodeAgg.c and nodeWindowAgg.c.Tom Lane
2022-08-04Fix failure to set correct operator in window run conditionDavid Rowley
2022-05-26Teach remove_unused_subquery_outputs about window run conditionsDavid Rowley
2022-04-07Teach planner and executor about monotonic window funcsDavid Rowley
2021-07-01Add tests for UNBOUNDED syntax ambiguityPeter Eisentraut
2020-11-04Declare lead() and lag() using anycompatible not anyelement.Tom Lane
2020-09-15Allow incremental sorts for windowing functionsDavid Rowley
2020-07-22Support infinity and -infinity in the numeric data type.Tom Lane
2020-07-21Fix some corner cases for window ranges with infinite offsets.Tom Lane
2019-10-03Selectively include window frames in expression walks/mutates.Andrew Gierth
2018-09-14Order active window clauses for greater reuse of Sort nodes.Andrew Gierth
2018-07-11Fix bugs with degenerate window ORDER BY clauses in GROUPS/RANGE mode.Tom Lane
2018-02-24Add window RANGE support for float4, float8, numeric.Tom Lane
2018-02-07Support all SQL:2011 options for window frame clauses.Tom Lane
2014-06-28Allow pushdown of WHERE quals into subqueries with window functions.Tom Lane
2014-04-13Provide moving-aggregate support for boolean aggregates.Tom Lane
2014-04-13Provide moving-aggregate support for a bunch of numerical aggregates.Tom Lane
2014-04-12Create infrastructure for moving-aggregate optimization.Tom Lane
2013-11-06Support default arguments and named-argument notation for window functions.Tom Lane
2013-07-17Implement the FILTER clause for aggregate function calls.Noah Misch
2012-09-13Fix case of window function + aggregate + GROUP BY expression.Tom Lane
2011-10-14Measure the number of all-visible pages for use in index-only scan costing.Tom Lane
2011-09-27Fix window functions that sort by expressions involving aggregates.Tom Lane
2011-07-12Avoid listing ungrouped Vars in the targetlist of Agg-underneath-Window.Tom Lane
2010-11-23Remove useless whitespace at end of linesPeter Eisentraut
2010-02-12Extend the set of frame options supported for window functions.Tom Lane
2009-08-27Modify the definition of window-function PARTITION BY and ORDER BY clausesTom Lane
2008-12-31Add some basic support for window frame clauses to the window-functionsTom Lane
2008-12-29Tighten up a couple of regression test cases that can have platform-dependentTom Lane
2008-12-28Support window functions a la SQL:2008.Tom Lane
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-25 09:06:09 +0000