Le vendredi 25 novembre 2011 23:14:31, Even Rouault a écrit :
> Hi,
>
> http://trac.osgeo.org/gdal/ticket/4354 :
>
> """Currently, OGR SQL considers COUNT(a_column) as a synonym of COUNT(*).
> However the standard mandates that COUNT(a_column) only count non-NULL
> values, whereas COUNT(*) count
Hi,
http://trac.osgeo.org/gdal/ticket/4354 :
"""Currently, OGR SQL considers COUNT(a_column) as a synonym of COUNT(*).
However the standard mandates that COUNT(a_column) only count non-NULL values,
whereas COUNT(*) count all rows (after the effect of WHERE clause of course).
So COUNT(a_column)