| Subject | Re: [firebird-support] Is rand() inclusive or exclusive? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2011-10-02T07:50:58Z |
On 2-10-2011 8:50, ruan_h wrote:
the same to apply to Firebird. I am not sure though.
--
Mark Rotteveel
> Hi AllRandomizers are usually 0 inclusive, upperbound exclusive; so I'd expect
>
> Both the ib_udf rand() and Firebird internal rand() have a description of "Returns a random number between 0 and 1". I'd expect it's exclusive on both ends (i.e. the number can never be 0 or 1), but the documentation is not absolutely clear on this, especially considering that in SQL BETWEEN...AND means inclusive. Can anyone confirm whether it's inclusive or exclusive?
the same to apply to Firebird. I am not sure though.
--
Mark Rotteveel