You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm trying to search on a field using $ilike but the field is an integer.
Using Postgres
The query is simple amount::text $ilike '%100%'. I would like to be able to indicate this from the clientside, but I can't seem to figure it out as the db will always wrap it with double quotes and throw an error.
This is what the query looks like: where (("amount::text" ilike '%100%'))
This is the postgres / objection error: operator does not exist: integer ~~* unknown
The text was updated successfully, but these errors were encountered:
I'm trying to search on a field using
$ilike
but the field is an integer.Using Postgres
The query is simple
amount::text $ilike '%100%'
. I would like to be able to indicate this from the clientside, but I can't seem to figure it out as the db will always wrap it with double quotes and throw an error.This is what the query looks like:
where (("amount::text" ilike '%100%'))
This is the postgres / objection error:
operator does not exist: integer ~~* unknown
The text was updated successfully, but these errors were encountered: