On 16/11/05, Maniac <[EMAIL PROTECTED]> wrote: > Oracle has 'rownum' - a virtual field representing the ordinal number of > a row. So you can do this: > > SELECT id, name FROM table where rownum<=5;
This specific issue is covered in the patch, but just for reference, the 'gotcha' with rownum is that it's applied before any ORDER BY clause is applied, so in most cases, it's not going to do what you want! That's why the classic solution is the one Jeremy posted, where you have to wrap the 'user' query in an "select * from () where rownum ...;" construct. I'm another one who'll be interested when Oracle's available, as that's the 'standard' (i.e. only) DB used in the company I develop for (or more to the point, their customers) and without it, there's no point even considering Django, much as I'd like to do so! /Gwyn
