Postgresql Random Rec Set - no Duplicates with Livecode
psahores at free.fr
Wed Feb 2 16:29:42 EST 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.
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!
> 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