<div dir="ltr"><div class="gmail_default" style="font-size:large">Hi all,<br><br></div><div class="gmail_default" style="font-size:large">I usually work with PostgreSQL data in QGIS. <br>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.<br><br></div><div class="gmail_default" style="font-size:large">I think the files are here<br>src/providers/postgres/qgspostgresexpressioncompiler.cpp<br>src/providers/postgres/qgspostgresfeatureiterator.cpp<br><br></div><div class="gmail_default" style="font-size:large">For example, I would like the following expression to be compiled server side:<br><br>    intersects(<br>        $geometry,<br>        geom_from_gml(<br>            '<gml:Polygon+xmlns:gml="<a href="http://www.opengis.net/gml">http://www.opengis.net/gml</a>"><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates+decimal="."+cs=","+ts="+">MY_GML_COORDINATES</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon>'<br>        )<br>    )<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">where MY_GML_COORDINATES is the GML version of a polygon ring coords.<br></div><div class="gmail_default" style="font-size:large"><br>What are the required steps to do so, and where ? The result would be<br><br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">    ST_Intersects(<br>        geom, <br>        ST_GeomFromGml( 'the long GML polygon representation')<br>    )<br></div><div class="gmail_default" style="font-size:large"><br></div><div class="gmail_default" style="font-size:large">Regards,<br></div><div class="gmail_default" style="font-size:large">Michaël<br></div></div>