How To Search An Enum In List Of Strings By Postgresql Query?

Consider a SQL Statement: select * from table where status in Where status is an enum: CREATE TYPE statusType AS ENUM ( 'enum1', 'enum2'; In Java I have a li

Solution 1:

You can cast the enum to text

handle.createQuery("select * from table where status::text in <statuses>")
                .bindList("statuses", statuses)
                .map(Mapper.instance)
                .list());