aggregate_with_lambda.sql 191 B

123456789101112
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. USE plato;
  4. $empty = ($list) -> {
  5. RETURN ListCreate(TypeOf($list[0]));
  6. };
  7. SELECT
  8. $empty(AGGREGATE_LIST(key))
  9. FROM Input
  10. GROUP BY value;