Hi,

I have a table with three int fields (a,b,c) and want to get the sum of them in a select this way:
select a+b+c as result from table

It seems that you cannot use expressions in the select, but only in the where clause. Is there a possibility to do such a select?

TIA,

Thorsten

Either :
- do your own user type (section 4.2.4)
- add a unmapped getter that compute
- "select new MyObject(a, b, c)" where MyObject will not be a persisted object

epbernard has great suggestions. The answer is no you cannot do expressions in the select clause of HQL. This will be addressed in the future as a new parser is being prototyped which makes this a little easier to do.
BTW: You can not have literals either.