add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
version
PostgreSQL 12.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit
7 rows affected
player_id wins losses cnt_games w_proportion w_percent
7 2 2 4 0.5 50.00
9 1 2 3 0.3333333333333333 33.33
ERROR:  function sum(boolean) does not exist
LINE 3:        ROUND(100 * SUM(result = 'W') / COUNT(result)) winnin...
                           ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

result
2
result
2.5
result
2.5000000000000000