Postgres 12

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