COALESCE

stevencummings · **Joined:** Thu Jan 19, 2006 2:36 pm **Posts:** 3

Does Hibernate/HQL support COALESCE?
For example:
select userid, COALESCE(ad.lastUpdtTs, dem.lastUpdtTs) as lastUpdtTs from ... order by lastUpdtTs

Thanks.

timrobertson100 · **Posted:** Thu Jan 26, 2006 4:59 am

Yeps - if your DB does. Chapter 14.9 (Expressions) in http://www.hibernate.org/hib_docs/v3/re ... ryhql.html

timrobertson100 · **Posted:** Thu Jan 26, 2006 5:00 am

Quote:

Expressions allowed in the where clause include most of the kind of things you could write in SQL

Note - only in where clause though

max · **Posted:** Thu Jan 26, 2006 5:30 am

define a function in the dialect and it should also work in the select clause.