summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorDavid Chorpash <davidchorpash@gmail.com>2020-07-20 10:15:53 +0200
committerMariusz Felisiak <felisiak.mariusz@gmail.com>2020-07-21 06:42:45 +0200
commita2e621b14e85836362b7fc0e6b1bf7d7ff98e42b (patch)
tree9ab544a8cf9dc67d5c7c5aca64afd5e62157e582 /docs
parent796be5901a67da44e251e092641682cb2d778176 (diff)
Refs #31720 -- Added examples to BoolAnd() and BoolOr() documentation.
Diffstat (limited to 'docs')
-rw-r--r--docs/ref/contrib/postgres/aggregates.txt28
1 files changed, 28 insertions, 0 deletions
diff --git a/docs/ref/contrib/postgres/aggregates.txt b/docs/ref/contrib/postgres/aggregates.txt
index b59555cb10..aad64a4db7 100644
--- a/docs/ref/contrib/postgres/aggregates.txt
+++ b/docs/ref/contrib/postgres/aggregates.txt
@@ -75,6 +75,20 @@ General-purpose aggregation functions
Returns ``True``, if all input values are true, ``None`` if all values are
null or if there are no values, otherwise ``False`` .
+ Usage example::
+
+ class Comment(models.Model):
+ body = models.TextField()
+ published = models.BooleanField()
+ rank = models.IntegerField()
+
+ >>> from django.db.models import BooleanField, Q
+ >>> from django.contrib.postgres.aggregates import BoolAnd
+ >>> Comment.objects.aggregate(booland=BoolAnd('published'))
+ {'booland': False}
+ >>> Comment.objects.aggregate(booland=BoolAnd(Q(rank__lt=100), output_field=BooleanField()))
+ {'booland': True}
+
``BoolOr``
----------
@@ -83,6 +97,20 @@ General-purpose aggregation functions
Returns ``True`` if at least one input value is true, ``None`` if all
values are null or if there are no values, otherwise ``False``.
+ Usage example::
+
+ class Comment(models.Model):
+ body = models.TextField()
+ published = models.BooleanField()
+ rank = models.IntegerField()
+
+ >>> from django.db.models import BooleanField, Q
+ >>> from django.contrib.postgres.aggregates import BoolOr
+ >>> Comment.objects.aggregate(boolor=BoolOr('published'))
+ {'boolor': True}
+ >>> Comment.objects.aggregate(boolor=BoolOr(Q(rank__gt=2), output_field=BooleanField()))
+ {'boolor': False}
+
``JSONBAgg``
------------