> One of the things I am having fun with is 'RAND' which is a function in
> postgres and MySQL that allows you to select a random record from a
> table. I have unique id's and so currently just look for a random SKIP
> based on number of records, but does anybody have a better way of doing it?

Depends on your definition of "random".
E.g. select without order clause is sort of random too

Are you looking for some random number generator algorithm,
or the way how to obtain n-th row without needing to skip lots of rows ?

Ivan