RetroSearch Browse

Fri Feb 14 11:54:35 CET 2014 · https://mail.python.org/pipermail/python-dev/2014-February/132342.html

On Fri, Feb 14, 2014 at 9:42 PM, Nick Coghlan <ncoghlan at gmail.com> wrote:
> IIRC, MySQL and PostgreSQL sort them in the opposite order from each
> other

Ouch! You're right:

http://dev.mysql.com/doc/refman/5.7/en/working-with-null.html

"""When doing an ORDER BY, NULL values are presented first if you do
ORDER BY ... ASC and last if you do ORDER BY ... DESC."""

Not configurable in MySQL. It's apparently not part of the standard,
according to Wikipedia:

http://en.wikipedia.org/wiki/Order_by

So definitely SQL's handling of NULL should not be any sort of guide
as regards Python's treatment of None.

ChrisA

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://mail.python.org/pipermail/python-dev/2014-February/132342.html below:

[Python-Dev] python 3 niggle: None < 1 raises TypeError