summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/window.out
Commit message (Expand)AuthorAgeFilesLines
* Fix incorrect logic for determining safe WindowAgg run conditionsDavid Rowley2023-03-171-14/+29
* Teach planner about more monotonic window functionsDavid Rowley2023-01-271-12/+14
* Get rid of the "new" and "old" entries in a view's rangetable.Tom Lane2023-01-181-28/+28
* Revert "Get rid of the "new" and "old" entries in a view's rangetable."Tom Lane2023-01-111-28/+28
* Get rid of the "new" and "old" entries in a view's rangetable.Tom Lane2023-01-111-28/+28
* Have the planner consider Incremental Sort for DISTINCTDavid Rowley2023-01-111-4/+6
* Add additional regression tests for select_active_windowsDavid Rowley2023-01-071-0/+98
* Fix recent accidental omission in pg_proc.datDavid Rowley2022-12-241-1/+7
* Allow window functions to adjust their frameOptionsDavid Rowley2022-12-231-0/+73
* Remove uses of MemoryContextContains in nodeAgg.c and nodeWindowAgg.c.Tom Lane2022-10-061-0/+17
* Fix failure to set correct operator in window run conditionDavid Rowley2022-08-051-0/+17
* Teach remove_unused_subquery_outputs about window run conditionsDavid Rowley2022-05-271-0/+19
* Teach planner and executor about monotonic window funcsDavid Rowley2022-04-081-0/+398
* Add tests for UNBOUNDED syntax ambiguityPeter Eisentraut2021-07-011-0/+140
* Declare lead() and lag() using anycompatible not anyelement.Tom Lane2020-11-041-0/+30
* Allow incremental sorts for windowing functionsDavid Rowley2020-09-151-0/+44
* Support infinity and -infinity in the numeric data type.Tom Lane2020-07-221-6/+60
* Fix some corner cases for window ranges with infinite offsets.Tom Lane2020-07-201-0/+72
* Selectively include window frames in expression walks/mutates.Andrew Gierth2019-10-031-0/+42
* Change floating-point output format for improved performance.Andrew Gierth2019-02-131-24/+24
* Order active window clauses for greater reuse of Sort nodes.Andrew Gierth2018-09-141-13/+47
* Fix bugs with degenerate window ORDER BY clauses in GROUPS/RANGE mode.Tom Lane2018-07-111-0/+95
* Add window RANGE support for float4, float8, numeric.Tom Lane2018-02-241-0/+185
* Support all SQL:2011 options for window frame clauses.Tom Lane2018-02-071-6/+1691
* to_char: revert cc0d90b73b2e6dd2f301d46818a7265742c41a14Bruce Momjian2015-03-221-1/+1
* to_char(float4/8): zero pad to specified lengthBruce Momjian2015-03-211-1/+1
* Allow pushdown of WHERE quals into subqueries with window functions.Tom Lane2014-06-271-0/+41
* Provide moving-aggregate support for boolean aggregates.Tom Lane2014-04-131-0/+12
* Provide moving-aggregate support for a bunch of numerical aggregates.Tom Lane2014-04-121-0/+475
* Create infrastructure for moving-aggregate optimization.Tom Lane2014-04-121-0/+223
* Improve EXPLAIN to print the grouping columns in Agg and Group nodes.Tom Lane2013-12-121-3/+4
* Support default arguments and named-argument notation for window functions.Tom Lane2013-11-061-0/+35
* Implement the FILTER clause for aggregate function calls.Noah Misch2013-07-161-0/+13
* Make the OVER keyword unreserved.Robert Haas2013-06-281-2/+2
* Perform line wrapping and indenting by default in ruleutils.c.Tom Lane2013-02-031-3/+5
* Fix case of window function + aggregate + GROUP BY expression.Tom Lane2012-09-131-0/+12
* Centralize the logic for detecting misplaced aggregates, window funcs, etc.Tom Lane2012-08-101-7/+7
* Measure the number of all-visible pages for use in index-only scan costing.Tom Lane2011-10-141-11/+12
* Fix window functions that sort by expressions involving aggregates.Tom Lane2011-09-261-0/+20
* Avoid listing ungrouped Vars in the targetlist of Agg-underneath-Window.Tom Lane2011-07-121-0/+7
* Remove useless whitespace at end of linesPeter Eisentraut2010-11-231-7/+7
* Extend the set of frame options supported for window functions.Tom Lane2010-02-121-0/+187
* Modify the definition of window-function PARTITION BY and ORDER BY clausesTom Lane2009-08-271-4/+4
* Add some basic support for window frame clauses to the window-functionsTom Lane2008-12-311-19/+141
* Tighten up a couple of regression test cases that can have platform-dependentTom Lane2008-12-291-5/+6
* Support window functions a la SQL:2008.Tom Lane2008-12-281-0/+672