Postgres DB search by id error

[msucevan]

Error:

ERROR: SQLSTATE[42883]: Undefined function: 7 ERROR: function upper(bigint) does not exist LINE 1: select count() as aggregate from "assets" where (UPPER(asse... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. (Connection: tenant, SQL: select count() as aggregate from "assets" where (UPPER(assets.id) LIKE %TRU% or (select "name" from "operations" where "operations"."id" = "assets"."operation_id" and "operations"."deleted_at" is null limit 1)::text ilike %tru% or UPPER(assets.name) LIKE %TRU% or (select "name" from "operations" where "operations"."id" = "assets"."operation_id" and "operations"."deleted_at" is null limit 1)::text ilike %tru% or UPPER(assets.erp_number) LIKE %TRU% or (select "name" from "operations" where "operations"."id" = "assets"."operation_id" and "operations"."deleted_at" is null limit 1)::text ilike %tru% or UPPER(assets.cutting_machine) LIKE %TRU% or (select "name" from "operations" where "operations"."id" = "assets"."operation_id" and "operations"."deleted_at" is null limit 1)::text ilike %tru%) and "assets"."deleted_at" is null)

Possible solution:

Do not use UPPER() on numeric columns like id.