Gwyn Evans wrote:
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
I know :-). That's why I didn't use ORDER BY in my example :-).
, so in most cases, it's not going to do what you
want!
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 t
Jacob Kaplan-Moss wrote:
> On Nov 16, 2005, at 7:04 AM, Pash wrote:
> > i saw a Ticket about an Oracle Backend. When will it be implemented in
> > Django? :)
>
> IIRC there are a few pretty major differences between Oracle and
> other RDBMSes that are preventing a Oracle backend from being
> "eas
On Nov 16, 2005, at 3:10 PM, Jeremy Dunck wrote:
select x from foo limit 10 offset 20
becomes:
select * from (
select x from foo
) where rownum between 20 and 30
Right; the issue is that query rewriting is... scary; making the
backend rewrite your queries for you sucessfully could be diffi
Jacob Kaplan-Moss wrote:
Off the top of my head, the big difference I can think of is that
Oracle doesn't support LIMIT/OFFSET on queries (you're supposed to
use a cursor or a temp table).
Oracle has 'rownum' - a virtual field representing the ordinal number of
a row. So you can do this:
On 11/16/05, Jeremy Dunck <[EMAIL PROTECTED]> wrote:
> On 11/16/05, Jacob Kaplan-Moss <[EMAIL PROTECTED]> wrote:
> > Off the top of my head, the big difference I can think of is that
> > Oracle doesn't support LIMIT/OFFSET on queries (you're supposed to
>
> This doesn't suck:
> http://e-docs.bea.c
On 11/16/05, Jacob Kaplan-Moss <[EMAIL PROTECTED]> wrote:
> Off the top of my head, the big difference I can think of is that
> Oracle doesn't support LIMIT/OFFSET on queries (you're supposed to
This doesn't suck:
http://e-docs.bea.com/workshop/docs81/doc/en/core/index.html
On Nov 16, 2005, at 12:58 PM, David S. wrote:
Jacob Kaplan-Moss jacobian.org> writes:
would you be up for testing a (possibly buggy) backend if I could get
one out?
I would like to volunteer as well. Are there unit tests or is that
part of
volunteering?
There are inteed unit tests of t
Jacob Kaplan-Moss jacobian.org> writes:
> would you be up for testing a (possibly buggy) backend if I could get
> one out?
I would like to volunteer as well. Are there unit tests or is that part of
volunteering?
Also, I am curious what the differences are and if versions matter.
On Nov 16, 2005, at 7:04 AM, Pash wrote:
i saw a Ticket about an Oracle Backend. When will it be implemented in
Django? :)
IIRC there are a few pretty major differences between Oracle and
other RDBMSes that are preventing a Oracle backend from being
"easy". I'll reinstall Oracle and take
Hi,
i saw a Ticket about an Oracle Backend. When will it be implemented in
Django? :)
Hi,
i saw a Ticket about an Oracle Backend. When will it be implemented in
Django? :)
Hi,
i saw a Ticket for that, when will it be implemented in Django? :)
13 matches
Mail list logo