postgresql - postgres tablefunc module using hql hibernate queries? -

would know how use postgres crosstab (tablefunc) function in hql query? need register function hibernate?

this error i'm getting:

unexpected token: crosstab near line 1, column 34 [select * crosstab('select ...  

thanks.

you cannot in hql, since hql different language independent of database implementations. if want use features specific postgresql (such crosstab) need native query interface.