blob: ed06206b42499d1b8a0b20d46a2b635f45c691de (
plain) (
blame)
1
2
3
4
5
6
7
|
/* syntax version 1 */
/* postgres can not */
use plato;
$data = (SELECT key, Just(aggregate_list(cast(subkey as uint32))) as lsk FROM plato.Input GROUP BY cast(key as uint32) as key);
SELECT key, lsk[0] FROM $data WHERE lsk IS NOT NULL ORDER BY key;
|
