Usually, the RAND() functions go from 0 to 0.999999999999999

Probably it is the same case in Firebird.

Greetings.

Walter.

On Sun, Oct 2, 2011 at 3:50 AM, Mark Rotteveel <mark@...> wrote:

> **
>
>
> 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
>
>
>


[Non-text portions of this message have been removed]