Commits

DateSubjectAuthorReleases
2024-01-10 Handle WindowClause.runCondition in tree walker/mutator functions. Tom Lane 16.2
2024-01-10 Handle WindowClause.runCondition in tree walker/mutator functions. Tom Lane 17.0
2022-10-06 Remove uses of MemoryContextContains in nodeAgg.c and nodeWindowAgg.c. Tom Lane 16.0
2020-11-04 Declare lead() and lag() using anycompatible not anyelement. Tom Lane 14.0
2020-07-22 Support infinity and -infinity in the numeric data type. Tom Lane 14.0
2020-07-21 Fix some corner cases for window ranges with infinite offsets. Tom Lane 14.0
2018-07-11 Fix bugs with degenerate window ORDER BY clauses in GROUPS/RANGE mode. Tom Lane 11.0
2018-07-11 Fix bugs with degenerate window ORDER BY clauses in GROUPS/RANGE mode. Tom Lane 12.0
2018-02-24 Add window RANGE support for float4, float8, numeric. Tom Lane 11.0
2018-02-07 Support all SQL:2011 options for window frame clauses. Tom Lane 11.0
2014-06-28 Allow pushdown of WHERE quals into subqueries with window functions. Tom Lane 9.5.0
2014-04-13 Provide moving-aggregate support for boolean aggregates. Tom Lane 9.4.0
2014-04-13 Provide moving-aggregate support for a bunch of numerical aggregates. Tom Lane 9.4.0
2014-04-12 Create infrastructure for moving-aggregate optimization. Tom Lane 9.4.0
2013-11-06 Support default arguments and named-argument notation for window functions. Tom Lane 9.3.2
2013-11-06 Support default arguments and named-argument notation for window functions. Tom Lane 9.4.0
2013-11-06 Support default arguments and named-argument notation for window functions. Tom Lane 9.2.6
2012-09-13 Fix case of window function + aggregate + GROUP BY expression. Tom Lane 9.2.1
2012-09-13 Fix case of window function + aggregate + GROUP BY expression. Tom Lane 9.3.0
2011-10-14 Measure the number of all-visible pages for use in index-only scan costing. Tom Lane 9.2.0
2011-09-27 Fix window functions that sort by expressions involving aggregates. Tom Lane 9.1.2
2011-09-27 Fix window functions that sort by expressions involving aggregates. Tom Lane 9.2.0
2011-07-12 Avoid listing ungrouped Vars in the targetlist of Agg-underneath-Window. Tom Lane 9.1.0
2011-07-12 Avoid listing ungrouped Vars in the targetlist of Agg-underneath-Window. Tom Lane 9.2.0
2010-02-12 Extend the set of frame options supported for window functions. Tom Lane 9.0.0