dict_lookup_column_names.sql 247 B

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