Hi José, On Thu, 26. Mar 2015 at 10:19:10 +0100, José Carlos Martínez Llario wrote: > "amenity" <> 'restaurant' returns 37 rows > "amenity" = 'restaurant' returns 11 rows > > The layers has 48 NULL values, so it means that amenity" <> > 'restaurant' does not take into account the null values. > Hope this is a bug and not the correct behaviour.
It's the correct behaviour. NULL <> 'restaurant' is NULL, ie. not true.
Use eg. coalesce('amenity','') <> 'restaurant'
Jürgen
--
Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31
Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50
Software Engineer D-26506 Norden http://www.norbit.de
QGIS release manager (PSC) Germany IRC: jef on FreeNode
signature.asc
Description: Digital signature
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
