[GRASS-user] POW() in SQLite?

[Rich Shepard]

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 stores most values as text strings so this is not surprising.

   I'd manipulate those values first, then pass them to SQLite.

Rich