From 3e09b37f80ab34cf57e245e1fcdabb3d4ff92a38 Mon Sep 17 00:00:00 2001 From: Sigurd Ljødal Date: Thu, 28 Sep 2017 22:28:48 +0200 Subject: Fixed #28649 -- Added ExtractIsoYear database function and iso_year lookup. --- django/db/backends/postgresql/operations.py | 2 ++ 1 file changed, 2 insertions(+) (limited to 'django/db/backends/postgresql') diff --git a/django/db/backends/postgresql/operations.py b/django/db/backends/postgresql/operations.py index f4e9571f81..b1b83861c1 100644 --- a/django/db/backends/postgresql/operations.py +++ b/django/db/backends/postgresql/operations.py @@ -31,6 +31,8 @@ class DatabaseOperations(BaseDatabaseOperations): if lookup_type == 'week_day': # For consistency across backends, we return Sunday=1, Saturday=7. return "EXTRACT('dow' FROM %s) + 1" % field_name + elif lookup_type == 'iso_year': + return "EXTRACT('isoyear' FROM %s)" % field_name else: return "EXTRACT('%s' FROM %s)" % (lookup_type, field_name) -- cgit v1.3