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?.
CREATE TABLE t
AS
SELECT 'Dog' AS c
UNION ALL
SELECT 'Cat'
UNION ALL
SELECT 'Bird'
UNION ALL
SELECT 'Goldfish'
SELECT 4
SELECT *
FROM t
WHERE c LIKE ANY (ARRAY['Do%', '%at'])
| c |
|---|
| Dog |
| Cat |
SELECT 2
SELECT *
FROM t
WHERE c LIKE ANY ('{"Do%", "%at"}')
| c |
|---|
| Dog |
| Cat |
SELECT 2
SELECT *
FROM t
WHERE c ~~ ANY (ARRAY['Do%', '%at'])
| c |
|---|
| Dog |
| Cat |
SELECT 2