Hello,
Id like to compare two arrays, and if any value is found in both, return
true. Is this possible without needing a procedure to loop through one?
For example, say categories is an array :
SELECT * FROM t1 WHERE ANY(ARRAY[5,7,9]) = ANY(categories);
Obviously this doesn't work, but you can kinda see what Im trying to do.
Thank you for any insight,
- A Gilmore