diff options
Diffstat (limited to 'docs/ref/contrib/postgres')
| -rw-r--r-- | docs/ref/contrib/postgres/functions.txt | 31 | ||||
| -rw-r--r-- | docs/ref/contrib/postgres/index.txt | 1 |
2 files changed, 32 insertions, 0 deletions
diff --git a/docs/ref/contrib/postgres/functions.txt b/docs/ref/contrib/postgres/functions.txt new file mode 100644 index 0000000000..c97af99bfb --- /dev/null +++ b/docs/ref/contrib/postgres/functions.txt @@ -0,0 +1,31 @@ +PostgreSQL specific database functions +====================================== + +All of these functions are available from the +``django.contrib.postgres.functions`` module. + +.. currentmodule:: django.contrib.postgres.functions + +TransactionNow +-------------- + +.. class:: TransactionNow() + +.. versionadded:: 1.9 + +Returns the date and time on the database server that the current transaction +started. If you are not in a transaction it will return the date and time of +the current statement. This is a complement to +:class:`django.db.models.functions.Now`, which returns the date and time of the +current statement. + +Note that only the outermost call to :func:`~django.db.transaction.atomic()` +sets up a transaction and thus sets the time that ``TransactionNow()`` will +return; nested calls create savepoints which do not affect the transaction +time. + +Usage example:: + + >>> from django.contrib.postgres.functions import TransactionNow + >>> Article.objects.filter(published__lte=TransactionNow()) + [<Article: How to Django>] diff --git a/docs/ref/contrib/postgres/index.txt b/docs/ref/contrib/postgres/index.txt index 7ff66d0770..a1536680c7 100644 --- a/docs/ref/contrib/postgres/index.txt +++ b/docs/ref/contrib/postgres/index.txt @@ -34,6 +34,7 @@ Psycopg2 2.5 or higher is required. aggregates fields forms + functions lookups operations validators |
