diff options
| author | Tom Lane | 2014-04-13 04:01:46 +0000 |
|---|---|---|
| committer | Tom Lane | 2014-04-13 04:01:46 +0000 |
| commit | d95425c8b9d3ea1681bd91b76ce73be95ca5ee21 (patch) | |
| tree | 18accad72b0619a3b46a23f8bf645b90f50b89b9 /src/test | |
| parent | 842faa714c0454d67e523f5a0b6df6500e9bc1a5 (diff) | |
Provide moving-aggregate support for boolean aggregates.
David Rowley and Florian Pflug, reviewed by Dean Rasheed
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/window.out | 12 | ||||
| -rw-r--r-- | src/test/regress/sql/window.sql | 4 |
2 files changed, 16 insertions, 0 deletions
diff --git a/src/test/regress/expected/window.out b/src/test/regress/expected/window.out index f08bd9c9adc..c2cc742c903 100644 --- a/src/test/regress/expected/window.out +++ b/src/test/regress/expected/window.out @@ -1769,3 +1769,15 @@ SELECT to_char(SUM(n::float8) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND 1 FO 1.0 (2 rows) +SELECT i, b, bool_and(b) OVER w, bool_or(b) OVER w + FROM (VALUES (1,true), (2,true), (3,false), (4,false), (5,true)) v(i,b) + WINDOW w AS (ORDER BY i ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING); + i | b | bool_and | bool_or +---+---+----------+--------- + 1 | t | t | t + 2 | t | f | t + 3 | f | f | f + 4 | f | f | t + 5 | t | t | t +(5 rows) + diff --git a/src/test/regress/sql/window.sql b/src/test/regress/sql/window.sql index 11c96aa8bc0..31c98eb2705 100644 --- a/src/test/regress/sql/window.sql +++ b/src/test/regress/sql/window.sql @@ -617,3 +617,7 @@ FROM (VALUES(1,1::numeric),(2,2),(3,'NaN'),(4,3),(5,4)) t(a,b); -- hard about it. SELECT to_char(SUM(n::float8) OVER (ORDER BY i ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING),'999999999999999999999D9') FROM (VALUES(1,1e20),(2,1)) n(i,n); + +SELECT i, b, bool_and(b) OVER w, bool_or(b) OVER w + FROM (VALUES (1,true), (2,true), (3,false), (4,false), (5,true)) v(i,b) + WINDOW w AS (ORDER BY i ROWS BETWEEN CURRENT ROW AND 1 FOLLOWING); |