在PostgreSQL中的数组列中查找字符串

I have built a series of views in a PostgreSQL database that includes a couple of array columns. The view definition is as follows:I have built a series of views in a PostgreSQL