Frank,<br><br>Can you list the statements supported by the WHERE clauses, like LIKE, IN and BETWEEN?<br><br>Is there a way to force through the SQL statement to the underlying database driver if required?<br><br><div class="gmail_quote">
On Mon, Aug 2, 2010 at 5:33 AM, Frank Warmerdam <span dir="ltr"><<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Folks,<br>
<br>
With the support of Camp To Camp I have been working on an overhaul for the<br>
OGR SQL parsing engine. The minimum goal was to support functions in the<br>
column definitions for the output record set of a SELECT, but in order to<br>
achieve this in a reasonable way I have worked towards a substantial<br>
generalization of expression in OGR SQL and extending them to column<br>
definitions.<br>
<br>
I have written up a preliminary RFC for review at:<br>
<br>
<a href="http://trac.osgeo.org/gdal/wiki/rfc28_sqlfunc" target="_blank">http://trac.osgeo.org/gdal/wiki/rfc28_sqlfunc</a><br>
<br>
I am seeking feedback before I polish it off and call for a vote this<br>
week.<br>
<br>
I will note that in my local development tree I now have this overhauled<br>
implementation working, including the autotest/ogr/{ogr_join_test.py,<br>
ogr_sql_test.py,ogr_index_test.py} test scripts all passing without<br>
alteration.<br>
<br>
Best regards,<br>
-- <br>
---------------------------------------+--------------------------------------<br>
I set the clouds in motion - turn up | Frank Warmerdam, <a href="mailto:warmerdam@pobox.com" target="_blank">warmerdam@pobox.com</a><br>
light and sound - activate the windows | <a href="http://pobox.com/%7Ewarmerdam" target="_blank">http://pobox.com/~warmerdam</a><br>
and watch the world go round - Rush | Geospatial Programmer for Rent<br>
<br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br>/tʃaɪθənjə/ /kʊmɑr/ <br>+91-9494447584<br>17.2416N 80.1426E<br>