There is a JSONB information field with this structure:
{
"ignore"=>false
}
I want to get all records whose ignore field is true:
@user.posts.where("information ->> 'ignore' = TRUE")
This line throws an error:
PG::UndefinedFunction: ERROR: operator does not exist: text = boolean
And I could not find anything in Google. Everywhere we are talking about textual meanings. But there is nothing about booleans.
You must cast the result of information->>'ignore' to boolean:
@user.posts.where("(information ->> 'ignore')::boolean = TRUE")
true and false are present.
\d+ posts in psql).jsonb information field in the table that contains what I showed in the text of the question. A simple table with simple fields.I had the same issue in upgrading to Rails 5/6. It seems the way the pg gem casts has changed a little, but this works for me:
@user.posts.where("(information ->> 'ignore')::boolean = ?", true)
When an argument is added as the second parameter to a where method call, ActiveRecord will do the work to cast this appropriately for you. If you add .explain to the query above, you should see something like:
EXPLAIN for: SELECT ... AND ((information ->> 'ignore')::boolean = TRUE) ...
