Postgresql Random Rec Set - no Duplicates with Livecode

[Rick Harrison]

Hi Pierre,

What I'm looking to do is to perform the Random pick from the database,
not reorder my results randomly after I've gotten all records.  I don't think
the code links below help me to do that.  I've been down this road already.

Thanks anyways!

Rick

On Feb 2, 2011, at 4:29 PM, Pierre Sahores wrote:

> It's a SQL syntax task, not a revDB one and as soon as the query will be OK, revDB will just handle it as expected.
> 
> <http://archives.postgresql.org/pgsql-general/2007-08/msg02034.php>
> <http://bytes.com/topic/postgresql/answers/857541-random-sample-rows>
> 
> Best regards,
> 
> Le 2 févr. 2011 à 21:29, Rick Harrison a écrit :
> 
>> Hi there,
>> 
>> I need to know the best way to get a random subset
>> of records without duplicates in the resulting record
>> set using a Postgresql database query with Livecode
>> on On-Rev.
>> 
>> In other words, I don't want to have to get all of the
>> records in the database first just to be able to pick
>> out the 21 random records i need, as that seems rather
>> inefficient.  Assume a couple of thousand records
>> in the database or more.
>> 
>> Thanks for your ideas in advance!
>> 
>> Rick
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

__________________________________
Rick Harrison

You can buy my $10 music album "Funny Time Machine" digital CD on the iTunes Store Now!

To visit the iTunes Store now to listen to samples of my CD please click on the
following link.  (Please note you must have iTunes installed on your computer for this link to work.)  

http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewAlbum?playListId=213668290