Rel8.Expr.Num

Documentation

fromIntegral :: (Sql DBIntegral a, Sql DBNum b, Homonullable a b) => Expr a -> Expr b

Cast DBIntegral types to DBNum types. For example, this can be useful if you need to turn an Expr Int32 into an Expr Double.

realToFrac :: (Sql DBNum a, Sql DBFractional b, Homonullable a b) => Expr a -> Expr b

Cast DBNum types to DBFractional types. For example, his can be useful to convert Expr Float to Expr Double.

div :: Sql DBIntegral a => Expr a -> Expr a -> Expr a

Perform integral division. Corresponds to the div() function.

mod :: Sql DBIntegral a => Expr a -> Expr a -> Expr a

Corresponds to the mod() function.

ceiling :: (Sql DBFractional a, Sql DBIntegral b, Homonullable a b) => Expr a -> Expr b

Round a DBFractional to a DBIntegral by rounding to the nearest larger integer.

Corresponds to the ceiling() function.

floor :: (Sql DBFractional a, Sql DBIntegral b, Homonullable a b) => Expr a -> Expr b

Round a DFractional to a DBIntegral by rounding to the nearest smaller integer.

Corresponds to the floor() function.

round :: (Sql DBFractional a, Sql DBIntegral b, Homonullable a b) => Expr a -> Expr b

Round a DBFractional to a DBIntegral by rounding to the nearest integer.

Corresponds to the round() function.

truncate :: (Sql DBFractional a, Sql DBIntegral b, Homonullable a b) => Expr a -> Expr b

Round a DBFractional to a DBIntegral by rounding to the nearest integer towards zero.