CURRENT_DATE is not supported since postgres7.2, use TODAY instead

1 files changed, 3 insertions, 1 deletions

diff --git a/db.py b/db.py
index c46e7af..a22b592 100644
--- a/db.py
+++ b/db.py
@@ -418,7 +418,9 @@ class _PGAdvFuncHelper(_GenericAdvFuncHelper):
     
     def sql_temporary_table(self, table_name, table_schema):
         return "CREATE TEMPORARY TABLE %s (%s) ON COMMIT DROP;" % (table_name,
-                                                                   table_schema)
+                                                                   table_schema)    
+    def sql_current_date(self):
+        return 'TODAY'
     
 
 class _SqliteAdvFuncHelper(_GenericAdvFuncHelper):