database query - array which does not include

Question

I have an array stored in element in DB. Currently using:

Item.where("something && ARRAY[?]::varchar[]", [1,2])

Which gives me the Items where the 'something' includes either a 1 or 2.

However, I need to find the items where the 'something' doesn't include either a 1 or a 2...

MZaragoza · Accepted Answer · 2016-03-30 15:26:12Z

3

I like to use the where.not clause

Item.where.not("something && ARRAY[?]::varchar[]", [1,2])

answered Mar 30, 2016 at 15:26

MZaragoza

10.1k9 gold badges76 silver badges117 bronze badges

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

1 Answer 1