aggregate_scalar_minus_zero.sql 118 B

12345678
  1. --!syntax_pg
  2. select x, count(*)
  3. from (
  4. select '+0.0'::float8 as x
  5. union all
  6. select '-0.0'::float8 as x
  7. ) a
  8. group by x