Qt_script_any

Definition

Language:	Qt Script
Plugin for language:	ScriptingQt
How to use:	Create custom SQL function, set it to "aggregate" type. Suggested name: any
Function arguments	Keep undefined
Function usage:	SELECT any(colName) from tableName
Description:	Picks random value from set of values of an aggregated column.

Code

Initialization code:

n=0;
winner={};

Per step code:

n++;
if (Math.random()*n >= n-1)
    winner=arguments[0];

Final step code:

return winner;