[GRASS-user] db.select driver issue

[Richard Chirgwin]

Micha Silver wrote:
> 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??
Whack. I think the cluestick just hit me. I will double-check the 
connection and try again ...

RC
>
>>>> 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.
>>
>>
>>    
>
>