blob: 6ee115121481506be3165131d5583875412cfb45 (
plain) (
blame)
1
2
3
4
5
|
/* syntax version 1 */
/* postgres can not */
use plato;
$dictList = (select AsDict(AsTuple(value, CAST(subkey AS Int32))) as `dict`, subkey, value from Input);
select input.`dict`[input.value], input.`dict`[input.subkey] from $dictList as input;
|