meta data for this page
  •  

F_DOUBLERANDOM

function from adhoc

Entrypoint doublerandom compatible with UTF-8

Inputs/Outputs

   Input      INTEGER        min. value of random-no.
              INTEGER        max. value of random-no.
   Output     DOUBLE         floatingpoint-random-number with value between parameter 1 and parameter 2

Syntax

   This function can create more than one different random-no. in one second because the generator is set with the actual systemtime and the process-ID, so that is is impossible, that 2 calls in the same second return the same random-no.
   TestSQL
   SELECT F_DOUBLERANDOM(100, 10000) FROM RDB$DATABASE;
   SELECT F_DOUBLERANDOM(NULL, NULL) FROM RDB$DATABASE;