Hello,
Michael Bayer said the following on 09.08.2007 22:53:
OK just to double check, the syntax looks like:
SELECT * FROM sometable ORDER BY foo NULLS FIRST
SELECT * FROM sometable ORDER BY foo DESC NULLS LAST
Yes.
? i.e. is DESC/ASC before the NULLS part ? or doesn't matter ?
It
OK ive added ticket #723 for this, it will go into 0.4xx.
On Aug 10, 2007, at 5:13 AM, Oleg Deribas wrote:
Hello,
Michael Bayer said the following on 09.08.2007 22:53:
OK just to double check, the syntax looks like:
SELECT * FROM sometable ORDER BY foo NULLS FIRST
SELECT * FROM
i was totally guessing mysql on this one...but its oracle ! who knew.
you're free to just use a string and say order_by=somecolumn NULLS
FIRST on this. we could add an operator to the oracle module if
that helps, something like (assume 0.4 usage)
Hello,
Michael Bayer said the following on 09.08.2007 17:09:
we could add an operator to the oracle module if
that helps, something like (assume 0.4 usage)
order_by=oracle.nullsfirst(mycolumn.desc()) , i guess that is
important if youre applying ordering to relations which get
ah that changes things...if NULLS FIRST/LAST is part of ANSI sql then
id feel comfortable adding a core construct, like
order_by=column.nullsfirst().
On Aug 9, 2007, at 12:27 PM, Oleg Deribas wrote:
Hello,
Michael Bayer said the following on 09.08.2007 17:09:
we could add an operator
Hello,
Michael Bayer said the following on 09.08.2007 20:50:
ah that changes things...if NULLS FIRST/LAST is part of ANSI sql then
id feel comfortable adding a core construct, like
order_by=column.nullsfirst().
Here is what I've found in SQL2003 draft:
In addition, NULLS FIRST or NULLS
OK just to double check, the syntax looks like:
SELECT * FROM sometable ORDER BY foo NULLS FIRST
SELECT * FROM sometable ORDER BY foo DESC NULLS LAST
? i.e. is DESC/ASC before the NULLS part ? or doesn't matter ?
we can add this to 0.4.