summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/window.out
AgeCommit message (Expand)Author
2025-11-24Improve detection of implicitly-temporary views.Tom Lane
2025-10-08Make truncate_useless_pathkeys() consider WindowFuncsDavid Rowley
2025-10-07Assign each subquery a unique name prior to planning it.Robert Haas
2025-10-03Add IGNORE NULLS/RESPECT NULLS option to Window functions.Tatsuo Ishii
2025-03-11Improve EXPLAIN's display of window functions.Tom Lane
2024-12-09Fix possible crash during WindowAgg evaluationDavid Rowley
2024-06-18Fix incorrect punctuation in error messagePeter Eisentraut
2024-05-05Fix query pullup issue with WindowClause runConditionDavid Rowley
2024-03-19Improve EXPLAIN's display of SubPlan nodes and output parameters.Tom Lane
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-18Get rid of the "new" and "old" entries in a view's rangetable.Tom Lane
2023-01-12Revert "Get rid of the "new" and "old" entries in a view's rangetable."Tom Lane
2023-01-12Get rid of the "new" and "old" entries in a view's rangetable.Tom Lane
2023-01-10Have the planner consider Incremental Sort for DISTINCTDavid 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
2019-02-13Change floating-point output format for improved performance.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
2015-03-23to_char: revert cc0d90b73b2e6dd2f301d46818a7265742c41a14Bruce Momjian
2015-03-22to_char(float4/8): zero pad to specified lengthBruce Momjian
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-12-12Improve EXPLAIN to print the grouping columns in Agg and Group nodes.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
2013-06-28Make the OVER keyword unreserved.Robert Haas
2013-02-03Perform line wrapping and indenting by default in ruleutils.c.Tom Lane
2012-09-13Fix case of window function + aggregate + GROUP BY expression.Tom Lane
2012-08-10Centralize the logic for detecting misplaced aggregates, window funcs, etc.Tom Lane