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

Nathan Woodrow madmanwoo at gmail.com
Sun Jun 1 23:57:18 PDT 2014


Yes it is, however there isn't a generic interface for the providers to do
it, and that feels like a bit of a hack to me. And you also have to handles
escaping, and all that messy stuff.  Better to have a explicit method that
handles all the extra logic.

- Nathan


On Mon, Jun 2, 2014 at 4:52 PM, Hugo Mercier <hugo.mercier at oslandia.com>
wrote:

> Hi,
>
> Le 30/05/2014 12:30, Nathan Woodrow a écrit :
>
> > My other idea is to allow the data providers to run a native query on
> > the connection/database and just return the result as a new layer.  This
> > would be a matter just passing a query string, running the query on the
> > provider, returning a new layer with the data.   The layers don't need
> > to be opened in QGIS.  Pretty much what DB Manager currently does but
> > done at a provider level, so we have it for each provider.
> >
>
> I am not sure to understand how is it different from the way DB manager
> does with a query, i.e. opening a layer and passing a query as the table
> name ?
> I mean, AFAIK, it's always executed at the provider level, isn't it ?
>
>
> _______________________________________________
> 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/20140602/77ff9f9e/attachment.html>


More information about the Qgis-developer mailing list