Merge pull request #42789 from MorriganR/fixROUNDexpressionPostgreSQL

[PostgreSQL] fix ROUND expression
qgis · Apr 15, 2021 · dbb1efd · dbb1efd
2 parents f93bd65 + cfef784
commit dbb1efd
Showing 1 changed file with 4 additions and 0 deletions.
diff --git a/src/providers/postgres/qgspostgresexpressioncompiler.cpp b/src/providers/postgres/qgspostgresexpressioncompiler.cpp
@@ -145,6 +145,10 @@ QStringList QgsPostgresExpressionCompiler::sqlArgumentsFromFunctionName( const Q
   {
     args << QStringLiteral( "8" );
   }
+  else if ( fnName == QLatin1String( "round" ) )
+  {
+    args[0] = QStringLiteral( "(%1)::numeric" ).arg( args[0] );
+  }
   // x and y functions have to be adapted
   return args;
 }