How to Check if PostgreSQL Array Contains Value greater than a Value

Question

Let's say I have several records with a column in type int[], and I want to find all the records containing at least one value greater than 200 in the array. How should I achieve that?

Sample data:

array
-------------
{18}
{489}
{218, 333, 100}
{23, 44, 102}

I would need to locate the second and third rows.

Saya · Accepted Answer · 2022-09-01 05:55:58Z

6

SELECT * FROM table1 WHERE 200 < ANY(arr);

answered Sep 1, 2022 at 5:55

Saya

3632 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

How to Check if PostgreSQL Array Contains Value greater than a Value

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