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 content as
select 'a'::text as value, 97 as dec, '0061' as hex union all
select 'b' as value, 98 as dec, '0062' as hex union all
select 'c' as value, 99 as dec, '0063' as hex union all
select 'd' as value, 100 as dec, '0064' as hex
4 rows affected
select regexp_replace(user_name, r.regex, '', 'g')
from (values ('Samuel'), ('Paul'), ('Chris')
) v(user_name) cross join lateral
(select '[^' || string_agg(value, '') || ']' as regex
from content
) r
| regexp_replace |
|---|
| a |
| a |