Re: [GRASS-user] sqrt sql

2019-03-08 Thread Frank David

Thank you very much Vero !

Frank

Le 08/03/2019 à 11:10, Veronica Andreo a écrit :

Hi

functionalities like sqrt() or log() are not available in base SQLite, 
then you have to install an extension


See v.db.update manual page and this wiki: 
https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_Linux


HTH,
Vero



El vie., 8 mar. 2019 05:22, Frank David > escribió:


Hello,

How Is it possible to calculate a sqrt from attribut fields to fill
another field, like :

v.db.update map=myvector column=field2 query_column=sqrt(field1)

Or is there any trick ?

Thank you

Frank
___
grass-user mailing list
grass-user@lists.osgeo.org 
https://lists.osgeo.org/mailman/listinfo/grass-user

___
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

Re: [GRASS-user] sqrt sql

2019-03-08 Thread Veronica Andreo
Hi

functionalities like sqrt() or log() are not available in base SQLite, then
you have to install an extension

See v.db.update manual page and this wiki:
https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_Linux

HTH,
Vero



El vie., 8 mar. 2019 05:22, Frank David  escribió:

> Hello,
>
> How Is it possible to calculate a sqrt from attribut fields to fill
> another field, like :
>
> v.db.update map=myvector column=field2 query_column=sqrt(field1)
>
> Or is there any trick ?
>
> Thank you
>
> Frank
> ___
> grass-user mailing list
> grass-user@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user
___
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

[GRASS-user] sqrt sql

2019-03-08 Thread Frank David

Hello,

How Is it possible to calculate a sqrt from attribut fields to fill 
another field, like :


v.db.update map=myvector column=field2 query_column=sqrt(field1)

Or is there any trick ?

Thank you

Frank
___
grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user