postgresql search column with integer[] with another array

Question

I am trying to figure out a way that I can search a column containing an array of integers. For example, column a -> [1,2]. Using another array, ex: b -> [1,2,3]

If all the values in a are in the array b, I want to return that result.

I've tried using unnest and = ANY but to no avail. Does anyone else have a solution to this?

user330315 · Accepted Answer · 2021-07-20 13:49:54Z

3

You can use the "contains" operator @>

array[1,2,3] @> array[1,2]

answered Jul 20, 2021 at 13:49

user330315

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

Collectives™ on Stack Overflow

postgresql search column with integer[] with another array

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related