Postgre SQL LIKE for Integer

Question

I have some problems in my project, we use PostgreSQL and Hibernate as ORM. I want to search my table for any type of column (INTEGER, STRING, TEXT). Where are the problems with Hibernate, I know that I can execute, for example, a LIKE operator of type INTEGER, for example:

select * from Table1 where size::text like '%3'; 

But damn Hibernate takes :: TEXT as the self parameter and throws an exception. How can I avoid this error? Thanks.

Answer 1

Try to do:

 cast(size as text) 

This should help.

Answer 2

This may not answer your question, however, if you want to find numbers ending in 3 , use the module operator

 select * from Table1 where (size % 10) == 3; 

Answer 3

Use CAST:

 select * from Table1 where CAST(size AS text) like '%3';