| Subject | Is rand() inclusive or exclusive? |
|---|---|
| Author | ruan_h |
| Post date | 2011-10-02T06:50:44Z |
Hi All
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?
Thanks
Huan
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?
Thanks
Huan