blob: 46f2a248c7b38116c5f62fadcabaf0b8d39b4b95 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
|
/* syntax version 1 */
/* postgres can not */
use plato;
select
sum(distinct cast(Unicode::ToLower(CAST(subkey AS Utf8)) as Int32)) + sum(distinct cast(Unicode::ToUpper(CAST(subkey AS Utf8)) as Uint64)) as sks,
ListSort(aggregate_list(distinct key || "_")) as kl
from Input3;
|
