This is an old revision of the document!


DRAFT

Omnidex SQL Function: $RANDOM

Description

Returns a pseudo-random number. The term “pseudo-random” is used as randomization is done using the Posix rand and srand functions. While these routines do provide satisfactory randomization for most applications, the numbers generated are not entirely random.

If seed is specified, it is used to start the random number generator. Note that only a single $random stream can be used in the process. If there are multiple $random functions in a select, only the first seed is used. Seed must be a literal. The return value is INTEGER length 4.

Syntax

$RANDOM[(seed)]

(seed)

Optional. Seed must be a literal.

Example

Example 1

$RANDOM(9)

68 6151 …

 
Back to top
dev/sql/functions/random.1260197201.txt.gz · Last modified: 2016/06/28 22:38 (external edit)