[Qgis-developer] Aggregates within expression engine

Matthias Kuhn matthias at opengis.ch
Wed Mar 16 00:47:34 PDT 2016

Hi Paolo,

On 03/16/2016 08:36 AM, Paolo Cavallini wrote:
> 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.

Sorry, I'm not familiar with the spreadsheet syntax. Can you make some
examples so we can compare the advantages and drawbacks in detail?

Thank you

More information about the Qgis-developer mailing list