blob: 45a8a6232f078a7f202d1ea4de2f8ee9b0cc6e3e (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
/* syntax version 1 */
/* postgres can not */
$in = SELECT
value,
SUM(unwrap(cast(subkey as uint32))) over w1 as sum1,
LEAD(value || value, 3) over w1 as dvalue_lead1,
SUM(cast(subkey as uint32)) over w2 as sum2,
LAG(cast(value as uint32)) over w2 as value_lag2,
FROM (SELECT * FROM plato.Input WHERE key = '1')
WINDOW
w1 as (PARTITION /*+ COMPACT() */ BY () ORDER BY value ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING),
w2 as (PARTITION COMPACT BY key ORDER BY value DESC ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING)
;
SELECT value, dvalue_lead1, value_lag2 FROM $in ORDER BY value;
|
