[GRASS-user] POW() in SQLite?

[Hamish]

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