blob: ccdac00de8e539e1a5ff6595abc6bda058ecf89f (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
/* syntax version 1 */
/* postgres can not */
define subquery $a() as
$_x = select 1;
discard
select ensure(1, true);
select 2;
$_y = select 2;
end define;
process $a();
define subquery $b() as
$f1 = ($row)->(<|a:1,b:$row.value|>);
$f2 = ($row)->(<|a:2,b:$row.value|>);
discard
process plato.Input using $f1(TableRow());
process plato.Input using $f2(TableRow());
end define;
select * from $b() order by b limit 1;
define subquery $c() as
$f1 = ($key,$_)->(<|a:1,b:$key|>);
$f2 = ($key,$_)->(<|a:2,b:$key|>);
discard
reduce plato.Input on key using $f1(TableRow());
reduce plato.Input on key using $f2(TableRow());
end define;
select * from $c() order by b limit 1;
|
