[GRASS-dev] problem with sql query
quentin.page at avignon.inra.fr
Wed Jul 1 02:00:39 EDT 2009
My database is postgres/postgis (pg)
error message :
error's synthaxe when i write whitout "." for query only one table
there's no error
Dylan Beaudette a écrit :
> On Tuesday 30 June 2009, Quentin Page wrote:
>> I try to interview two vectors with tables with SQL query.
>> when I write :
>> echo "update table table1 set attribute1 = 1 where table1.attribute2 =
>> table2.attribute2" |db.execute
>> I receive an error message. Is there a syntax error with the point
>> between tables and attributes?
>> Any idea? Can I use sql query to interview two tables in the
>> same time?
> What is the database back-end? As far as I know, you cannot use update
> statements like this with the DBF back-end.
More information about the grass-dev