weak_field_aggregation.sql 225 B

12345678910
  1. /* postgres can not */
  2. USE plato;
  3. --INSERT INTO Output
  4. SELECT
  5. odd,
  6. sum(WeakField(data3, "int32") + WeakField(datahole3, "uint32", 999)) as score
  7. FROM Input4
  8. GROUP BY cast(subkey as uint32) % 2 as odd
  9. ORDER BY odd, score