Postgres WHERE any(arrayPostgres) = any(arrayParameter)

Question

how is the following condition working? i have an postgres array and call a function with an array as paramter. As condition i want to check the following:

WHERE any(array[x,y]) = any(array[y,z])

Thus is minimum one element of the postgres array in the parameter array?

Nick Barnes · Accepted Answer · 2020-03-20 09:05:21Z

1

You can do this with the overlap operator:

WHERE array[x,y] && array[y,z]

answered Mar 20, 2020 at 9:05

Nick Barnes

21.8k5 gold badges63 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Postgres WHERE any(arrayPostgres) = any(arrayParameter)

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