More robust detection for domain constraint

git-svn-id: http://svn.osgeo.org/qgis/trunk/qgis@15347 c8812cc2-4d05-0410-92ff-de0c093fc19c
qgis · Mar 5, 2011 · 261ed74 · 261ed74
1 parent 3d52473
commit 261ed74
Showing 1 changed file with 1 addition and 2 deletions.
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -2062,8 +2062,7 @@ bool QgsPostgresProvider::parseDomainCheckConstraint( QStringList& enumValues, c
       //(VALUE = ANY (ARRAY['a'::text, 'b'::text, 'c'::text, 'd'::text]))
       //normally, postgresql creates that if the contstraint has been specified as 'VALUE in ('a', 'b', 'c', 'd')
 
-      //todo: ANY must occure before ARRAY
-      int anyPos = checkDefinition.indexOf( "VALUE=ANY" );
+      int anyPos = checkDefinition.indexOf( QRegExp( "VALUE\\s*=\\s*ANY\\s*\\(\\s*ARRAY\\s*\\[" ) );
       int arrayPosition = checkDefinition.lastIndexOf( "ARRAY[" );
       int closingBracketPos = checkDefinition.indexOf( "]", arrayPosition + 6 );