Exists some function random() ? like in postgres.
if i want to used the function random of postgres, how is the procedure?

thanks

There isn't a random() funciton in HQL, but random() is defined in the PostgreSQL dialect file, so you should be able to use it. What dialect are you using? If it's not PostgreSQLDialect, then you'll have to register the SQL function in your dialect. Have a look at PostgreSQLDialect's constructor for function registration code.