postgresql and RoR - how quering a json type field where value is in an array

Question

Say I have a User class with a json type address field that has keys for city and country like this: adress: {city: 'NY', country: 'USA'} and I want to get all the users that live in an array of country names like: country_names = ['Iran', 'Iraq', 'Yemen']. How do can I do it in Ruby on Rails?

I've tried:

User.where("address->>'country' IN ?", country_names)

but I get a syntax error. what is the correct way?

Claudi · Accepted Answer · 2014-09-15 13:19:51Z

1

The list of values of the IN clause should be enclosed by parentheses:

User.where("address->>'country' IN (?)", country_names)

answered Sep 15, 2014 at 13:19

Claudi

5,4361 gold badge19 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

postgresql and RoR - how quering a json type field where value is in an array

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