Skip to main content

random

Function random 

Source
pub fn random<'a, V>() -> SQLExpr<'a, V, <V::DialectMarker as RandomPolicy>::Random, NonNull, Scalar>
where V: SQLParam + 'a, V::DialectMarker: RandomPolicy,
Expand description

RANDOM - returns a random value.

Return type is dialect-aware:

  • SQLite: integer in [-2^63, 2^63)
  • PostgreSQL: float in [0, 1)

ยงExample

use drizzle_core::expr::random;

// SELECT RANDOM()
let rnd = random::<SQLiteValue>();