summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorChad Shryock <chad@isl.co>2016-06-02 10:52:58 -0700
committerTim Graham <timograham@gmail.com>2016-06-02 19:43:08 -0400
commit9d52cdfbbc02a21fafc74146c571ac6e50812a00 (patch)
tree32fa6bc33acd6c32bbd01824291212451da4f2aa /docs
parent95ed1514f0947a6a8f461046d15bc9273517a754 (diff)
[1.9.x] Fixed #26526 -- Documented QuerySet.latest()'s dependency on database ordering.
Backport of e6c5e68acd4bff90e371fd148ed6976e147692ad from master
Diffstat (limited to 'docs')
-rw-r--r--docs/ref/models/querysets.txt11
1 files changed, 11 insertions, 0 deletions
diff --git a/docs/ref/models/querysets.txt b/docs/ref/models/querysets.txt
index a5c7937f1c..9d9c312466 100644
--- a/docs/ref/models/querysets.txt
+++ b/docs/ref/models/querysets.txt
@@ -1954,6 +1954,17 @@ given parameters.
Note that ``earliest()`` and ``latest()`` exist purely for convenience and
readability.
+.. admonition:: ``earliest()`` and ``latest()`` may return instances with null dates.
+
+ Since ordering is delegated to the database, results on fields that allow
+ null values may be ordered differently if you use different databases. For
+ example, PostgreSQL and MySQL sort null values as if they are higher than
+ non-null values, while SQLite does the opposite.
+
+ You may want to filter out null values::
+
+ Entry.objects.filter(pub_date__isnull=False).latest('pub_date')
+
``earliest()``
~~~~~~~~~~~~~~