diff options
Diffstat (limited to 'docs/ref')
| -rw-r--r-- | docs/ref/models/querysets.txt | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/docs/ref/models/querysets.txt b/docs/ref/models/querysets.txt index 47eefdb579..223bb452b0 100644 --- a/docs/ref/models/querysets.txt +++ b/docs/ref/models/querysets.txt @@ -712,6 +712,14 @@ You can also refer to fields on related models with reverse relations through pronounced if you include multiple such fields in your ``values()`` query, in which case all possible combinations will be returned. +.. admonition:: Special values for ``JSONField`` on SQLite + + Due to the way the ``JSON_EXTRACT`` and ``JSON_TYPE`` SQL functions are + implemented on SQLite, and lack of the ``BOOLEAN`` data type, + ``values()`` will return ``True``, ``False``, and ``None`` instead of + ``"true"``, ``"false"``, and ``"null"`` strings for + :class:`~django.db.models.JSONField` key transforms. + ``values_list()`` ~~~~~~~~~~~~~~~~~ @@ -782,6 +790,14 @@ not having any author:: >>> Entry.objects.values_list('authors') <QuerySet [('Noam Chomsky',), ('George Orwell',), (None,)]> +.. admonition:: Special values for ``JSONField`` on SQLite + + Due to the way the ``JSON_EXTRACT`` and ``JSON_TYPE`` SQL functions are + implemented on SQLite, and lack of the ``BOOLEAN`` data type, + ``values_list()`` will return ``True``, ``False``, and ``None`` instead of + ``"true"``, ``"false"``, and ``"null"`` strings for + :class:`~django.db.models.JSONField` key transforms. + ``dates()`` ~~~~~~~~~~~ |