blob: df60a53b836a8f25dadedd22158304b572a66323 (
plain) (
blame)
1
2
3
4
5
|
/* syntax version 1 */
/* postgres can not */
$data = (select mod, aggregate_list(value) as lv from plato.Input group by cast(key as uint32) % 10 as mod);
select mod, iv from $data as d flatten by lv as iv where iv < 'd' order by mod, iv;
|
