If you have a lot of tips, you could create a unique indexed tip number
column. Select the highest tip number using:
select tip_number from tips order by tip_number desc limit 1;
Then generate a random number and select using that tip_number.
Of course, you would have to allow for the possibility of missing tip
numbers, by repeating the random number generation/read sequence until you
find something. Since the tip_number isn't the PK of the table, you can
regenerate the tip numbers to eliminate holes from deletions any time you
like. Just reset the sequence to 1 and update all rows with the
Sounds like a lot of work to me though...
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2004-03-11 06:40:06|
|Subject: Re: randomized order in select? |
|Previous:||From: azwa||Date: 2004-03-11 01:51:08|
|Subject: Re: designer tool connect to PostgreSQL|