1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
/* postgres can not */
$d1 = AsDict(
AsTuple(AsList(1,2,3),"foo"),
AsTuple(AsList(1,2),"bar")
);
$d2 = AsDict(
AsTuple(AsList(1,3),"baz"),
AsTuple(AsList(1,2),"qwe")
);
$d3 = DictCreate(DictKeyType(TypeOf($d2)), DictPayloadType(TypeOf($d2)));
$d = AsDict(
AsTuple($d1, 17),
AsTuple($d2, 32)
);
select ListSort(ListFlatten(ListMap(DictItems($d), ($x) -> {return ListMap(DictItems($x.0), ($y) -> {return ($y, $x.1)})}))),
ListSort(ListFlatten(ListMap(DictKeys($d), ($x) -> {return DictItems($x)}))),
ListSort(DictPayloads($d));
select DictLookup($d,$d1), DictLookup($d,$d3);
select DictContains($d,$d1), DictContains($d,$d3);
|
