Why is there an error in the SQL query?

Question

SQL

I am writing a request to check the available data for the presence of elements in the pattern:

select model
from product
where model like '_2%' and model like '%1'

but why do I get this error:

ERROR: ОШИБКА:  оператор не существует: integer ~~ unknown
LINE 3: where model like '_2%' and model like '%1'
                    ^
HINT:  Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.


SQL state: 42883
Character: 39

Answer 1

select model
from product
where cast(model as text) like '%1'
union
select model
from product
where cast(model as text) like '_2%'