On Tue, 15 Jan 2008 14:43:35 +0100 Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > You need to scroll to the last row to find the size of the result > set, but after that it's pretty easy to return random rows by > scrolling to them (and marking them 'read' in some way to prevent > accidentally returning the same row again). Could you post a snippet of code or something giving a more detailed idea of it? BTW since cursors support offset if you're not interested if the order of the retrieved rows is random too you don't even have to remember which one you read I think. -- Ivan Sergio Borgonovo http://www.webthatworks.it ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
