diff options
Diffstat (limited to 'docs/ref')
| -rw-r--r-- | docs/ref/models/database-functions.txt | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/docs/ref/models/database-functions.txt b/docs/ref/models/database-functions.txt index da67d9e362..f5efdb7e87 100644 --- a/docs/ref/models/database-functions.txt +++ b/docs/ref/models/database-functions.txt @@ -87,6 +87,25 @@ Usage examples:: >>> now = timezone.now() >>> Coalesce('updated', Cast(now, DateTimeField())) +``Collate`` +----------- + +.. class:: Collate(expression, collation) + +.. versionadded:: 3.2 + +Takes an expression and a collation name to query against. + +For example, to filter case-insensitively in SQLite:: + + >>> Author.objects.filter(name=Collate(Value('john'), 'nocase')) + <QuerySet [<Author: John>, <Author: john>]> + +It can also be used when ordering, for example with PostgreSQL:: + + >>> Author.objects.order_by(Collate('name', 'et-x-icu')) + <QuerySet [<Author: Ursula>, <Author: Veronika>, <Author: Ülle>]> + ``Greatest`` ------------ |