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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
