In a previous thread, I mentioned trouble with Grass-GIS's database
driver on complex queries, but couldn't remember an example.
I've bumped into one this morning. In MySQL, this query works fine:
select sum(population) from australia
in Grass-GIS:
echo "select sum(population) from Australia" | db.select -c
returns:
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected '(', expecting FROM
processing '('
in statement:
select sum(population) from Australia
Error in db_open_select_cursor()
Richard
_______________________________________________
grass-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/grass-user
