How to check if a cell of type integer array contains a certain value in SQL

Question

I'm using postgresql. How can I check if a cell (type integer[]) contains a certain value? There is a cell (row_of_type_integer_array) is a row of type integer[]. There is one cell containing the values {2, 3, 4}

Now I want sth like: if there is a cell containg the value 2 (not only 2, but also 2), then return sth. This would be the case in the given cell mentioned above.

I tried this:

SELECT id FROM table_name WHERE row_of_type_integer_array = 2;

However this isn't working. I also tried this:

SELECT id FROM table_name WHERE 2 IN row_of_type_integer_array;

But this isn't working either. Which way can I go else?

404 · Accepted Answer · 2017-10-10 15:31:21Z

2

Many ways to do it. Here's one:

SELECT id FROM table WHERE 2 = ANY(row_of_type_integer_array)

answered Oct 10, 2017 at 15:31

404

8,7522 gold badges33 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

How to check if a cell of type integer array contains a certain value in SQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related