postgres provider: cast to text in uniqueStringsMatching (fixes #19180)

qgis · Sep 19, 2018 · e3f63d8 · e3f63d8
1 parent bbfccdc
commit e3f63d8
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -1663,7 +1663,7 @@ QStringList QgsPostgresProvider::uniqueStringsMatching( int index, const QString
       sql += QStringLiteral( " ( %1 ) AND " ).arg( mSqlWhereClause );
     }
 
-    sql += QStringLiteral( " %1 ILIKE '%%2%'" ).arg( quotedIdentifier( fld.name() ), substring );
+    sql += QStringLiteral( " %1::text ILIKE '%%2%'" ).arg( quotedIdentifier( fld.name() ), substring );
 
 
     sql += QStringLiteral( " ORDER BY %1" ).arg( quotedIdentifier( fld.name() ) );