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

[Bob and Deb]

How about querying the sqlite_master table to find the data type?  And why
not use the constraints found in this query to set up the qgis relations?

-Bob (aka cgs_bob on freenode)
On May 27, 2014 6:04 AM, "Régis Haubourg" <
regis.haubourg at eau-adour-garonne.fr> wrote:

> 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]
>
> [0]
>
> http://sqlite.1065341.n5.nabble.com/Computed-columns-in-VIEWs-return-NULL-but-should-be-able-to-be-typed-Any-ideas-td56769.html#a56770
>
> [1]
>
> http://osgeo-org.1560.x6.nabble.com/Spatialite-can-t-type-fields-of-a-view-td5058436.html
>
>
>
>
> --
> 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.
> _______________________________________________
> Qgis-developer mailing list
> Qgis-developer at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-developer
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20140528/5c880c80/attachment.html>