Richard, FYI the problem may be located at the driver level: with 'pg' driver this query works fine.
Bye, Vincent Le dimanche 28 mars 2010 à 08:54 +1100, Richard Chirgwin a écrit : > 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 > grass-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/grass-user > _______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user