[GRASS-user] db.select driver issue

[Vincent Bain]

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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>