[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3536?page=c... ] Hauke Rabe commented on HHH-3536: --------------------------------- In case of an aggregate projections for a boolean value PSQL is different to Oracle. PSQL has a boolean type whereas Oracle normally uses a int. So the query works on Oracle but not on PSQL cause of "function min(boolean) does not exist". SQL Oracle: select min(this.booleanValue) from Foo this SQL PSQL: select min(case when this.booleanValue then 1 else 0) from Foo this -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira