order by rand()?

[Carseason]

how order by rand?

[randree]

Can you provide an example how to use this? Also, is there a way of using "RANDOM()" in case of Postgres database?

[DarkAngel7]

Can you provide an example how to use this? Also, is there a way of using "RANDOM()" in case of Postgres database?

Here is some sample code to select random rows from table.

err = unusedWordsQuery.
     Order(field.Func.Rand()).
     Limit(num).
     Scan(&wordIds)

[randree]

Thanks for the answer!
Unfortunately, I'm working with Postgres and there is no function RAND() only RANDOM().
I found a solution but its not very beautiful.

... := q.ReplaceDB(q.Product.UnderlyingDB().Clauses(clause.OrderBy{
		Expression: clause.Expr{SQL: "RANDOM()"},
	})).Product.Find()