[GRASS-user] Square root in SQL Builder

[Markus Neteler]

Hi Thiago,

On Tue, Jan 30, 2024 at 1:05 AM Thiago Statella via grass-user
<grass-user at lists.osgeo.org> wrote:
>
> Hi everyone!
>
> I need to populate a column in attribute table based on the square root of entries from another column.
> I tried the field calculator with no success. It seams that SQRT function is not supported by SQLite driver.
> Any help would be highly appreciated.

Functionalities like sqrt() or log() are not available in base SQLite
(an issue unrelated to GRASS GIS). You will have to install an SQLite extension.

See the v.db.update manual page and these wiki pages:
- https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_Linux
- https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_windows

Regards,
Markus

--
Markus Neteler, PhD
https://www.mundialis.de - company
https://grass.osgeo.org - FOSS
https://neteler.org - blog & freelancing