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 <[email protected]> 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] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
