[gdal-dev] OGR SQL Parser/Evaluator Overhaul

Chaitanya kumar CH chaitanya.ch at gmail.com
Sun Aug 1 23:48:54 EDT 2010


Frank,

Can you list the statements supported by the WHERE clauses, like LIKE, IN
and BETWEEN?

Is there a way to force through the SQL statement to the underlying database
driver if required?

On Mon, Aug 2, 2010 at 5:33 AM, Frank Warmerdam <warmerdam at pobox.com> wrote:

> Folks,
>
> With the support of Camp To Camp I have been working on an overhaul for the
> OGR SQL parsing engine.  The minimum goal was to support functions in the
> column definitions for the output record set of a SELECT, but in order to
> achieve this in a reasonable way I have worked towards a substantial
> generalization of expression in OGR SQL and extending them to column
> definitions.
>
> I have written up a preliminary RFC for review at:
>
>  http://trac.osgeo.org/gdal/wiki/rfc28_sqlfunc
>
> I am seeking feedback before I polish it off and call for a vote this
> week.
>
> I will note that in my local development tree I now have this overhauled
> implementation working, including the autotest/ogr/{ogr_join_test.py,
> ogr_sql_test.py,ogr_index_test.py} test scripts all passing without
> alteration.
>
> Best regards,
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam<http://pobox.com/%7Ewarmerdam>
> and watch the world go round - Rush    | Geospatial Programmer for Rent
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>



-- 
Best regards,
Chaitanya kumar CH.
/tʃaɪθənjə/ /kʊmɑr/
+91-9494447584
17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100802/093d6ce4/attachment.html


More information about the gdal-dev mailing list