[postgres] Compile make_date, make_datetime, make_time functions

Allows (most) vector temporal filters to be performed server-side, utilising indexes on the temporal fields. Ultimately makes it possible to animate huge postgres tables using the new temporal framework.
qgis · May 15, 2020 · 9f09406 · 9f09406
1 parent c13b677
commit 9f09406
Showing 1 changed file with 3 additions and 0 deletions.
diff --git a/src/providers/postgres/qgspostgresexpressioncompiler.cpp b/src/providers/postgres/qgspostgresexpressioncompiler.cpp
@@ -104,6 +104,9 @@ static const QMap<QString, QString> FUNCTION_NAMES_SQL_FUNCTIONS_MAP
   { "lower", "lower" },
   { "trim", "trim" },
   { "upper", "upper" },
+  { "make_date", "make_date" },
+  { "make_time", "make_time" },
+  { "make_datetime", "make_timestamp" },
 };
 
 QString QgsPostgresExpressionCompiler::sqlFunctionFromFunctionName( const QString &fnName ) const