On 2-10-2011 8:50, ruan_h wrote: > 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?
Randomizers are usually 0 inclusive, upperbound exclusive; so I'd expect the same to apply to Firebird. I am not sure though. -- Mark Rotteveel
