Postgresql Random Rec Set - no Duplicates with Livecode
psahores at free.fr
Thu Feb 3 01:51:54 EST 2011
You welcome, Rick.
PS: PostgreSQL, the amazing diamond of the ACID-SQL db world ;-)
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!
> 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
mobile : (33) 6 03 95 77 70
More information about the Use-livecode