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
Sorry I didnt explain well. Forget about the second part of the email, I
was talking about syntax, of course is well-known that NULL and 'NULL'
are two different things but that was not my point):
So this this the problem that I would like an answer:
The table has 4635 rows, which 4587 are
Thanks for the answer Jürgen, didnt know that QGIS used normal database
null logic which is fantastic.
Cheers,
Jose
On 26/03/2015 10:53, Jürgen E. Fischer wrote:
Hi José,
On Thu, 26. Mar 2015 at 10:19:10 +0100, José Carlos Martínez Llario wrote:
amenity'restaurant' returns 37 rows
Hi List,
Im using some data from OSM, I used this data directly from osm file and
converted to shape file too. In both cases same results:
The layers has 4635 rows:
amenity'restaurant' returns 37
amenity = 'restaurant' returns 11
The layers has 48 NULL values, so it means that
Am 25.03.2015 um 20:07 schrieb José Carlos Martínez Llario:
The layers has 48 NULL values,
...
THIS IS OK
amenity is not NULL returns 48
amenity is NULL returns 4587
This does not make nuch sense to me. Do you have 48 empty (NULL)
entries, or 48 non-empty values?
THIS IS WRONG