Postgresql Random Rec Set - no Duplicates with Livecode

[Rick Harrison]

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