[Qgis-developer] have aggregate/window expressions ever been discussed?

Régis Haubourg regis.haubourg at eau-adour-garonne.fr
Tue May 27 06:03:48 PDT 2014

Hugo Mercier wrote
> Or
>> calculated fields in view can't be explicitly cast, so QGIS should have
>> to
>> guess data type based on a data scan (a major unadressed issue of sqlite)
> Hmmm I wasn't aware of this limitation in SQLITE views :(

Yes, SQLITE does dynamic typing, so user or provider has to scan values to
guess the right type. 
Here is a sqlite topic on that [0]
And here my initial post in qgis list [1]



View this message in context: http://osgeo-org.1560.x6.nabble.com/have-aggregate-window-expressions-ever-been-discussed-tp5142215p5142714.html
Sent from the Quantum GIS - Developer mailing list archive at Nabble.com.

More information about the Qgis-developer mailing list