[GRASS-user] db.select driver issue

[Micha Silver]

On 03/28/2010 11:08 AM, Vincent Bain wrote:
> 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:
>>>        
So is it a dbf driver or mysql?
db.connect -p??

>>> 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
>>
>>      
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>
> This mail was received via Mail-SeCure System.
>
>
>    


-- 
Micha Silver
http://www.surfaces.co.il/
Arava Development Co.  +972-52-3665918