Re: [GRASS-user] POW() in SQLite?

> Hamish wrote: > > I am trying to use POW(x,n) with SQLite but it fails: ... > > no such function: POW Glynn: > Nope; not in SQLite: > http://www.sqlite.org/lang_corefunc.html > .. > > Similar problem if I try x^n: > > unrecognized token: "^" > > SQLite doesn't have a power operator: >

Re: [GRASS-user] POW() in SQLite?

Hamish wrote: > 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 Nope; not in SQLite: http://www.sqlite.org/lang_c

Re: [GRASS-user] POW() in SQLite?

On Mon, 1 Mar 2010, Hamish wrote: I am trying to use POW(x,n) with SQLite but it fails: Hamish, Mathematical functions such as POW() are not part of SQL. When you look at what appear to be mathematical functions, e.g., ABS(). MIN(), MAX(), they are actually string manipulations. SQLite s

[GRASS-user] POW() in SQLite?

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: ... unrecogniz