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?.
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
1 rows affected
bonus_id |
---|
1 |
2 |
uhb_id | user_id | bonus_id |
---|---|---|
1 | 10 | 1 |
2 | 11 | 1 |
3 | 10 | 2 |
id |
---|
10 |
11 |
ERROR: column "bonus_ids" does not exist
LINE 9: WHERE bonuses.bonus_id IN (BONUS_IDS)
^
HINT: Perhaps you meant to reference the column "bonuses.bonus_id".