PostgreSQL: Compare Two Arrays Is Any One Value Exists In Second Array

Question

I am trying to join two tables and each table having one array column. And my intension is to compare two arrays if any value of the first array exists in the second array.

I am writing where clause like below

any(table1.array1) = any(table2.array2)

But it is not working for me.

Without seeing your table structures and sample data it is very hard to answer this question. — Nick
– Nick, Commented Sep 23, 2020 at 5:01

Sharif · Accepted Answer · 2020-09-23 05:37:23Z

4

Operator && should do the trick. This will return if any of elements in Array1 is present in Array2. Refer to PostgreSQL document here: Array Operators

select array[1,2,3] && array[2,4,5], array[1,2,3] && array[4,5, 6], array[1,2,3] && array[1]
Output: true, false, true

If you are looking if all the elements present in second array, you should use @> or <@

answered Sep 23, 2020 at 5:37

Sharif

3223 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL: Compare Two Arrays Is Any One Value Exists In Second Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related