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.

doc_Django
2016-10-09 18:35:45
Comments
Leave a Comment

Please login to continue.