Re: Random PostreSQL

Doug, Thanks for the extensive reply. The problem that I was referring to is that I have no idea of knowning how many records will be in the database. It won't necessarily be a consistent number, or even close. That's what I meant by saying that oidrand() wouldn't work for what I needed. I changed the 10 to 1, 2, 3, etc and nothing was giving me a standard number. I figured that when the database got full populated it would work out, however, I didn't want to go on that assumption, or assume that there would always be a certain number of records in the database, if that makes sense. I don't like relying on guesses for my applications. Anyhow, thanks a lot for the extensive reply. Joe