[Qgis-developer] Aggregates within expression engine

Paolo Cavallini cavallini at faunalia.it
Wed Mar 16 00:36:09 PDT 2016

Il 16/03/2016 08:30, Neumann, Andreas ha scritto:

> Why do you think SQL aggregate syntax (e.g. as outlined
> at http://www.postgresql.org/docs/9.5/interactive/functions-aggregate.html)
> is a no-go? Can you explain this in detail? QGIS is much closer to a
> database then it is to a spreadsheet - in fact for most serious QGIS
> work you store your data in a SQL database.
> It was my impression that QGIS tries to maintain expression syntax
> compatible with SQL wherever possible. I think it would be a good thing.

Hi Andreas,
based on my lengthy experience with courses, I'm pretty sure SQL
commands are out of reach for most "normal" GIS users.
It is fine to have access to SQL for power users, but aggregate
functions should IMHO be available to anyone.
All the best.
Paolo Cavallini - www.faunalia.eu
QGIS & PostGIS courses: http://www.faunalia.eu/training.html

More information about the Qgis-developer mailing list