Hi Michaël, No functions are compiled so far (afaik).
One will need to implement this in qgssqlexpressioncompiler or qgspostgresexpressioncompiler for all the functions involved (I'm not sure if / to what degree these functions are compatible between different sql dialects). Also make sure that any new function which is compiled is unit tested (providertestbase.py) to make sure it behaves exactly the same when executed locally and server side - across all providers. It's a long-standing plan of mine but I haven't found the time (or contract) for this yet... Matthias On 11/15/2016 11:01 AM, kimaidou wrote: > Hi all, > > I usually work with PostgreSQL data in QGIS. > I would like to have a guidance on how to improve the set of compiled > expressions for PostgreSQL. My goal is to propose a PR for some spatial > function. > > I think the files are here > src/providers/postgres/qgspostgresexpressioncompiler.cpp > src/providers/postgres/qgspostgresfeatureiterator.cpp > > For example, I would like the following expression to be compiled server > side: > > intersects( > $geometry, > geom_from_gml( > > '<gml:Polygon+xmlns:gml="http://www.opengis.net/gml";><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates+decimal="."+cs=","+ts="+">MY_GML_COORDINATES</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon>' > ) > ) > > where MY_GML_COORDINATES is the GML version of a polygon ring coords. > > What are the required steps to do so, and where ? The result would be > > > ST_Intersects( > geom, > ST_GeomFromGml( 'the long GML polygon representation') > ) > > Regards, > Michaël > > > _______________________________________________ > Qgis-developer mailing list > [email protected] > List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer > _______________________________________________ Qgis-developer mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer
