summaryrefslogtreecommitdiff
path: root/docs/ref
diff options
context:
space:
mode:
authorNick Pope <nick@nickpope.me.uk>2021-06-30 00:08:27 +0100
committerMariusz Felisiak <felisiak.mariusz@gmail.com>2021-07-19 13:41:16 +0200
commitfee87345967b3d917b618533585076cbfa43451b (patch)
tree202561eec2284ce1bd3ae4793d32ac346b068848 /docs/ref
parent501a8db46595b2d5b99c1d3b1146a832f43cdf1c (diff)
Refs #10929 -- Deprecated forced empty result value for PostgreSQL aggregates.
This deprecates forcing a return value for ArrayAgg, JSONBAgg, and StringAgg when there are no rows in the query. Now that we have a ``default`` argument for aggregates, we want to revert to returning the default of ``None`` which most aggregate functions return and leave it up to the user to decide what they want to be returned by default.
Diffstat (limited to 'docs/ref')
-rw-r--r--docs/ref/contrib/postgres/aggregates.txt21
1 files changed, 21 insertions, 0 deletions
diff --git a/docs/ref/contrib/postgres/aggregates.txt b/docs/ref/contrib/postgres/aggregates.txt
index 61ec86fa44..6d85d5c478 100644
--- a/docs/ref/contrib/postgres/aggregates.txt
+++ b/docs/ref/contrib/postgres/aggregates.txt
@@ -52,6 +52,13 @@ General-purpose aggregation functions
from django.db.models import F
F('some_field').desc()
+ .. deprecated:: 4.0
+
+ If there are no rows and ``default`` is not provided, ``ArrayAgg``
+ returns an empty list instead of ``None``. This behavior is deprecated
+ and will be removed in Django 5.0. If you need it, explicitly set
+ ``default`` to ``Value([])``.
+
``BitAnd``
----------
@@ -138,6 +145,13 @@ General-purpose aggregation functions
Examples are the same as for :attr:`ArrayAgg.ordering`.
+ .. deprecated:: 4.0
+
+ If there are no rows and ``default`` is not provided, ``JSONBAgg``
+ returns an empty list instead of ``None``. This behavior is deprecated
+ and will be removed in Django 5.0. If you need it, explicitly set
+ ``default`` to ``Value('[]')``.
+
``StringAgg``
-------------
@@ -164,6 +178,13 @@ General-purpose aggregation functions
Examples are the same as for :attr:`ArrayAgg.ordering`.
+ .. deprecated:: 4.0
+
+ If there are no rows and ``default`` is not provided, ``StringAgg``
+ returns an empty string instead of ``None``. This behavior is
+ deprecated and will be removed in Django 5.0. If you need it,
+ explicitly set ``default`` to ``Value('')``.
+
Aggregate functions for statistics
==================================