postgresql - How to make a select with array contains value clause in psql

Question

I have column arr which is of type array.

I need to get rows, where arr column contains value s

This query:

SELECT * FROM table WHERE arr @> ARRAY['s']

gives the error:

ERROR: operator does not exist: character varying[] @> text[]

Why does it not work?

p.s. I know about any() operator, but why doesn't @> work?

Answer 1

Try

SELECT * FROM table WHERE arr @> ARRAY['s']::varchar[]