PostgreSQL: Check if any item from array exists in the db property, which is array too

Question

Looking for a way to check if one of the items of given array exists in db property, which is also an array. I have a table 'Events', which has a property weekDays, which is an array of numbers [1,2,3,4,5]. Given an array searchDays which is [2,3], I want to check if the one of the items exists in weekDays.

coladict · Accepted Answer · 2018-01-19 09:10:25Z

2

This means you need to look for overlap. The operator is &&

SELECT * FROM Events where weekDays && ARRAY[2,3]

answered Jan 19, 2018 at 9:10

coladict

5,1151 gold badge20 silver badges31 bronze badges

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

Comments

Vao Tsun · Accepted Answer · 2018-01-19 09:28:35Z

1

you are looking for intersecion I suppose:

t=# with c(weekdays,searchdays) as (values(array[1,2,3,4,5],array[2,3]))
select weekdays && searchdays from c;
 ?column?
----------
 t
(1 row)

edited Jan 19, 2018 at 9:28

answered Jan 19, 2018 at 9:11

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Collectives™ on Stack Overflow

PostgreSQL: Check if any item from array exists in the db property, which is array too

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related