Hi Thomas, I just checked and the integrated search is indeed working fine for me (Safari on Mac). I had searched for "random" on the functions page using my browser's built-in search capability and found "RANDOM_UUID", but I missed the "RAND" function. I guess I'm just not used to sites' built-in search working well enough to trust them. :-) Thanks for the pointer, and sorry for wasting your time.
On Sat, Jan 3, 2009 at 6:18 AM, Thomas Mueller <[email protected]> wrote: > > Hi, > > I have a question. Is the integrated search function in the web site > working for you? On the web site http://h2database.com if I click on > the field below "Search:" on the far left and type 'rand' I get a link > to 'Functions'. If I click on it, I am redirected to > > http://www.h2database.com/html/functions.html?highlight=RAND&search=rand#firstFound > > If I then click on the yellow 'RAND' I am redirected to > > http://www.h2database.com/html/functions.html?highlight=RAND&search=rand#rand > > Maybe you have disabled Javascript? If yes why? If not, what browser > are you using? > > Regards, > Thomas > > > On Mon, Dec 29, 2008 at 4:48 AM, [email protected] > <[email protected]> wrote: >> >> Is there a random() function in H2? I'd like to do something like the >> following: >> >> select * from my_table order by random() limit 1 >> >> to get a random row from my_table. >> >> Thanks >> >> >> > >> > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
