blob: 98838fb5fe4debee2ce7afd02a0df7701f28e12f (
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
33
34
|
/* syntax version 1 */
/* postgres can not */
use plato;
$x = CAST(Unicode::ToLower("foo"u) AS String);
select AsStruct("1" as foo, 2 as bar).$x;
$x = CAST(Unicode::ToLower("value"u) AS String);
select key, t.$x from Input as t order by key;
$x = CAST(Unicode::ToLower("value"u) AS String);
select key, TableRow().$x from Input order by key;
$x = CAST(Unicode::ToLower("value"u) AS String);
select * from Input as t order by t.$x;
$x = CAST(Unicode::ToLower("value"u) AS String);
$y = CAST(Unicode::ToLower("key"u) AS String);
select x,count(*) from Input as t group by t.$x as x
having min(t.$y) != ""
order by x;
select a.$x as x,b.$y as y from Input as a join Input as b on (a.$x = b.$x)
order by x;
select a.$x as x,b.$y as y from Input as a join Input as b using ($x)
order by x;
select p, value, lag(value) over w as lag
from Input
window w as (partition by TableRow().$y as p order by TableRow().$x)
order by p, value;
|
