You welcome, Rick. PS: PostgreSQL, the amazing diamond of the ACID-SQL db world ;-)
Best, Pierre Le 3 févr. 2011 à 03:37, Rick Harrison a écrit : > Hi Pierre, > > I tried "ORDER BY random() LIMIT 21" > > It does work the way I want it to. > > It was just the way they described it work, that > didn't sound correct. It sounded like the code > would just select the first 21 records which > met my 'true' requirement in the database and > then reorder them randomly. (Not what I wanted.) > > I made up a test where I assigned my own > record values from 1-49 and then used > the above code. My results were: > > record #41 > record #3 > record #24 ... > > for a total of 21 records. > So everything does seem to work correctly. > > What does hashfloat8 do for one? > > Thanks, all is well again! > > Rick > > On Feb 2, 2011, at 6:09 PM, Pierre Sahores wrote: > >> SELECT * >> FROM table >> WHERE condition = true >> ORDER BY hashfloat8(random()) >> LIMIT 10 > > > > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Pierre Sahores mobile : (33) 6 03 95 77 70 www.woooooooords.com www.sahores-conseil.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode