[Qgis-developer] NULL handling and numeric data types

Andreas Neumann a.neumann at carto.net
Wed Sep 24 08:55:42 PDT 2014


Thank you Matthias for the very quick fix.

This fix only changes the NULL value behavior of the widget - right?

This will probably have no effect on what QGIS server does with NULL
values, right?

Thanks a lot,
Andreas

Am 24.09.2014 15:13, schrieb Matthias Kuhn:
> Just implemented it for text edit (when using QgsFilterLineEdit or
> QLineEdit). [1]
> 
> Please let me know if it works and if you are missing it in other places
> as well.
> 
> Matthias
> 
> [1]
> https://github.com/qgis/QGIS/commit/3f8a860503c78689c981234f874771f8b1277c97
> 
> On 24.09.2014 16:59, Matthias Kuhn wrote:
>> Hi Andreas,
>>
>> I think we can. It should be quite easy. Let me give it a try.
>>
>> Matthias
>>
>> On 24.09.2014 16:51, Andreas Neumann wrote:
>>> Hi,
>>>
>>> I frequently have data with NULL values and still have problems with
>>> QGIS correctly handling them.
>>>
>>> While QGIS displays NULL values of text types correctly as NULL, NULL
>>> values of numeric data types (e.g. smallint, double, numeric) just
>>> display as an empty string. I would rather like to see NULL instead of
>>> the empty string in the widget.
>>>
>>> Can we do something about that so that NULL values are correctly
>>> displayed as NULL also for numeric data types?
>>>
>>> QGIS server even displays numeric values with NULL values as "0" instead
>>> of "NULL" - which is wrong in my opinion. It is misleading as 0 and NULL
>>> are not the same.
>>>
>>> My data is in Postgis and I tested both with 2.4 and current master.
>>>
>>> Thanks,
>>> Andreas
>>>
>>> _______________________________________________
>>> Qgis-developer mailing list
>>> Qgis-developer at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>> _______________________________________________
>> Qgis-developer mailing list
>> Qgis-developer at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-developer
> 
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
> 



More information about the Qgis-developer mailing list