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 |