db.models.functions.Least

class Least(*expressions, **extra) [source]

New in Django 1.9.

Accepts a list of at least two field names or expressions and returns the least value. Each argument must be of a similar type, so mixing text and numbers will result in a database error.

Warning

The behavior of Least when one or more expression may be null varies between databases:

PostgreSQL: Least will return the smallest non-null expression, or null if all expressions are null.
SQLite, Oracle, and MySQL: If any expression is null, Least will return null.

The PostgreSQL behavior can be emulated using Coalesce if you know a sensible maximum value to provide as a default.

Links:

https://docs.djangoproject.com/en/1.10/ref/models/database-functions/#django.db.models.functions.Least

doc_Django

2025-01-10 15:47:30

Comments

Popular Articles

db.models.functions.Substr class Substr(expression, pos, length=None, **extra) [source] Returns a substring of length length from the field or expression starting at positio

db.models.functions.Lower class Lower(expression, **extra) [source] Accepts a single text field or expression and returns the lowercase representation. It can also be regis

db.models.functions.Cast class Cast(expression, output_field) [source] New in Django 1.10. Forces the result type of expression to be the one from output_field. Usage ex

db.models.functions.Upper class Upper(expression, **extra) [source] Accepts a single text field or expression and returns the uppercase representation. It can also be regis

db.models.functions.Greatest class Greatest(*expressions, **extra) [source] New in Django 1.9. Accepts a list of at least two field names or expressions and returns the grea