/* 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);