With the new inverted index support on arrays https://www.cockroachlabs.com/docs/stable/array.html, is it possible to perform a contains query that will check if ANY item in an array is present in the table?
ie: I have a row with a column of ARRAY[‘sky’, ‘road’, ‘car’]
Can I issue a single query for
SELECT * FROM my_table WHERE arr_column @> ANY(ARRAY[‘sky’, ‘bird’, tree’];
will return the given row?
Is there an efficient way to do this without a joins table?