Views random seed

Categories

Component ID

394648

Component name

Views random seed

Component type

module

Maintenance status

Development status

Component security advisory coverage

covered

Downloads

20346

Component created

Component changed

Component body

Adds a random order handler with seed. If a constant integer argument N is specified in the sql RAND() function, it is used as the seed value, which produces a repeatable sequence of column values. This makes it possible to have paging and not having items show up twice.
It's also possible to compute a custom seed using PHP, allowing you to create pseudo randoms numbers based on variables such as the date of the day.

More info:
- MySQL: http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#funct... about RAND() and the optional integer argument.
- PostgreSQL: http://www.postgresql.org/docs/current/interactive/functions-math.html about RANDOM() and the 'select setseed' function.