Hi, I am trying to use POW(x,n) with SQLite but it fails:
G65> v.db.select mapname column="POW(length,3)" DBMI-SQLite driver error: Error in sqlite3_prepare():SELECT POW(length,3) FROM mapname no such function: POW ERROR: Unable to open select cursor Similar problem if I try x^n: ... unrecognized token: "^" ERROR: Unable to open select cursor What I really want to do is add that value as a new column: G65> v.db.update mapname column=volume value="POW(length,3)" --verbose but I get the same error. It doesn't work with DBF either, but I sort of expected that. this random webhit suggests that it should be possible: http://osdir.com/ml/sqlite-users/2009-03/msg00248.html any ideas? not a DB guru, Hamish _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
