The operator does not exist: bigint ~~ unknown Rails 5

Navigation
0

On the controller: 

@sales = Sale.where("id like ?", "%#{sales_number}%")

The url I request 

http://localhost:3000/sales/sales/search?utf8=%E2%9C%93&sales_number=1000&button=

The error 

PG::UndefinedFunction: ERROR:  el operador no existe: bigint ~~ unknown
LINE 1: SELECT "sales".* FROM "sales" WHERE (id like '%1000%')
                                                ^

HINT 

Ningún operador coincide con el nombre y el tipo de los argumentos. Puede ser necesario agregar conversiones explícitas de tipos.
    : SELECT "sales".* FROM "sales" WHERE (id like '%1000%')
    
asked by Juan David Zubiria Torrenegra 07.01.2018 в 04:57
source

1 answer

1

I found the solution: 

@sales = Sale.where("CAST(id AS TEXT) ILIKE ?", "%#{sales_number}%")
    
answered by 07.01.2018 в 05:38
how can I use the names of the wordpress pages as header text? Error writing to file, you can not concatenate str a bytes