Thanks for the confirmation. I'll tweak my queries accordingly. Craig
On Thu, Feb 11, 2010 at 10:53 AM, Frank Warmerdam <warmer...@pobox.com>wrote: > Miller, Craig wrote: > >> I was browsing the PostGIS driver code today and noticed that when used >> with ExecuteSQL the spatial filters appear to be getting applied on the >> client side instead of the PostGIS side. Am I understanding the code >> correctly? >> > > Craig, > > Yes, that is correct. When using ExecuteSQL() we pass on the SQL > directly without alternation which means we need to do the spatial > query manually after the fact. > > On the other hand, when you access postgres/postgis through a normal > OGRLayer, we do attempt to incorporate the spatial and attribute filters > into the internally generated SQL used to read the features. > > Best regards, > -- > > ---------------------------------------+-------------------------------------- > I set the clouds in motion - turn up | Frank Warmerdam, > warmer...@pobox.com > light and sound - activate the windows | http://pobox.com/~warmerdam > and watch the world go round - Rush | Geospatial Programmer for Rent > > -- Craig Miller Geospatial Software Architect
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
