Maxm, avg and Min function

Tobia · **Joined:** Wed Sep 09, 2009 4:15 am **Posts:** 14

Hello, I have this HQL:

Code:

select max(stat.durataelaborazione/stat.numeropagine), avg(stat.durataelaborazione/stat.numeropagine), min(stat.durataelaborazione/stat.numeropagine)...

But I get a Long, Double, Long object, why? A division between long can be a double! How can i change this behaviour?

Thanks.

Tobia · **Joined:** Wed Sep 09, 2009 4:15 am **Posts:** 14

Nobody can help me, please?

Tobia · **Joined:** Wed Sep 09, 2009 4:15 am **Posts:** 14

What do you mean? I know this, but i think i have a trouble with hibernate not with Oracle.

I have two Long fields, if my HQL is:

Code:

select max(Field/Filed2)

I expect a Double value, not a Long like for a simple max(Filed)

sanne.grinovero · **Posted:** Wed Aug 04, 2010 9:01 am

Quote:

What do you mean?

sorry, that was spam and I removed it.

Quote:

But I get a Long, Double, Long object, why? A division between long can be a double! How can i change this behaviour?

I'm not sure how you can change that. did you try using casts in the hql? or you could use a resulttransformet, or define a value object for the query and have something like:

Code:

select new Dto(max(stat.durataelaborazione/stat.numeropagine), avg(stat.durataelaborazione/stat.numeropagine), min(stat.durataelaborazione/stat.numeropagine)) ...

(provided you create a Dto having the appropriate constructors; that's what I usually do as I prefer to deal with objects with properties than with arrays of things of different types.)