Postgresql Random Rec Set - no Duplicates with Livecode

Pierre Sahores psahores at free.fr
Wed Feb 2 15:29:42 CST 2011


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







More information about the use-livecode mailing list