[Qgis-developer] Aggregates within expression engine

[Matthias Kuhn]

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
Matthias