ActiveRecord: search by array field element inside another array

Question

I have an object with an array field, called emails

user.emails = ['[email protected]','[email protected]']

I want to find all the users from a list of emails:

emails_to_find = ['[email protected]','[email protected]']

I tried running

User.where(emails: emails_to_find)

but I get

ActiveRecord::StatementInvalid: PG::InvalidTextRepresentation: ERROR:  array value must start with "{" or dimension information

How do I do that? What the error means?

ggsp · Accepted Answer · 2019-03-05 17:42:26Z

3

If the column is of type Array and in the migration that created it you have something like t.string 'emails', array: true, try using:

User.where("emails @> ARRAY[?]::varchar[]", ['[email protected]','[email protected]'])
User.where("'[email protected]' = ANY (emails)")

ggsp

4525 silver badges17 bronze badges

answered Sep 9, 2014 at 8:07

Roman Kiselenko

44.5k9 gold badges100 silver badges111 bronze badges

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

1 Answer 1