Hibernate/JPA CriteriaQuery trim function generate wrong SQL for PostgreSQL

I'm trying to use the Criteria Query trim() function to strip the leading zero's of a field in the database. The relevant part of the criteria query is:

The SQL generated by this snippet is:

This leads to the following exception from Postgres:

PSQLException: ERROR: function pg_catalog.ltrim(character varying, integer) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.

Expected generated SQL:

Forum discussion: Hibernate/JPA CriteriaQuery trim function wrong SQL Postgres
SO Question: http://stackoverflow.com/questions/41579182/does-hibernate-jpa-criteriaquery-trim-function-generate-the-wrong-sql-for-postgr