-- creating a test table
create table postgres_report_bug (
    id serial,
    some_date timestamp with time zone
);

-- Inserting some data
insert into postgres_report_bug (some_date)
SELECT dd
FROM generate_series('2019-11-11'::timestamp, now(), '1 hour'::interval) dd;

-- It's not working
select *, to_char(some_date, 'day') from postgres_report_bug
    where (to_char(some_date, 'day')::text = any ('{monday, tuesday}'::text[]))

-- It's working
select *, to_char(some_date, 'day') from postgres_report_bug
    where (to_char(some_date, 'd')::int = any ('{2, 3}'::int[]))

-- It's working
select *, to_char(some_date, 'day') from postgres_report_bug
    where (to_char(some_date, 'day')::text = any ('{wednesday}'::text[]))
