Postgre SQL LIKE for Integer

Question

I've some problem in my project, we use PostgreSQL and Hibernate as ORM. I want to perform search in my table for any column type (INTEGER, STRING, TEXT). Where are some problem with Hibernate, I know what I can execute for example LIKE operator on INTEGER type like this:

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

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

Answer 1

Try doing:

cast(size as text)

It should help.

Answer 2

Use CAST:

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