Postgres-Queries in Rails: where not

Question

I use Rails with PostgreSQL and it works perfectly for queries like this:

# Does hstore_column contain key?

scoped_users = User.where('hstore_column ? :key', key: 'name_of_key')

Now my problem: How can I invert this query / how can I find all users which do not have a specific key specified?

# I tried this query amongst others, but it does not work:

scoped_users = User.where('hstore_column ? :key = FALSE', key: 'name_of_key')

Thanks for you help!

araqnid · Accepted Answer · 2012-07-24 14:54:08Z

2

Try:

where('NOT ( hstore_column ? :key )', key: 'name_of_key')

answered Jul 24, 2012 at 14:54

araqnid

135k25 gold badges163 silver badges138 bronze badges

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

1 Answer 1