Hi: El dom, 02-06-2002 a las 02:10, Steve Tyler escribi�: > Hi All, > > I've been having a tough time coming up with a good way to do this: > > - I have a (postgresql) DB table containing quoteId, quote, author > - I want to have a randomly selected quote appear on a web page > > Can anyone suggest an efficient way to do this without having to pull in > a bunch on data?
What about something like this? SELECT quotedId, quote, author from your_table order by random() limit 1; HTH -- Saludos, Roberto Andrade Fonseca [EMAIL PROTECTED]
