Postgresql Random Rec Set - no Duplicates with Livecode

[Rick Harrison]

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