[GRASS-user] POW() in SQLite?

Hamish hamish_b at yahoo.com
Mon Mar 1 00:55:47 EST 2010


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:

any ideas?

not a DB guru,

More information about the grass-user mailing list