blob: ae78304cbdf75be6fdfc2e0ef0101ebc15c1ca8e (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
|
/* postgres can not */
USE plato;
$list = (select item FROM (select AsList('foo', 'bar', 'baz', 'quux', 'bat') as `list`) FLATTEN BY `list` as item);
--INSERT INTO Output
SELECT
item, YQL::Concat('+', Lead(item, 1) over w), YQL::Concat("++", Lead(item,2) over w)
FROM $list
WINDOW w as ();
|
