<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thanks for the answer Jürgen, didnt know that QGIS used normal
database null logic which is fantastic.<br>
Cheers,<br>
Jose<br>
<br>
<br>
<div class="moz-cite-prefix">On 26/03/2015 10:53, Jürgen E. Fischer
wrote:<br>
</div>
<blockquote cite="mid:20150326095324.GA11357@norbit.de" type="cite">
<pre wrap="">Hi José,
On Thu, 26. Mar 2015 at 10:19:10 +0100, José Carlos Martínez Llario wrote:
</pre>
<blockquote type="cite">
<pre wrap="">"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.
</pre>
</blockquote>
<pre wrap="">
It's the correct behaviour. NULL <> 'restaurant' is NULL, ie. not true.
Use eg. coalesce('amenity','') <> 'restaurant'
Jürgen
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
------------------------------
José Carlos Martínez Llario
<a class="moz-txt-link-freetext" href="http://cartosig.upv.es">http://cartosig.upv.es</a>
Producción Cartográfica y SIG.
Dpto. Ingeniería Cartográfica.
Univ. Politécnica de Valencia.
------------------------------</pre>
</body>
</html>