[prev in list] [next in list] [prev in thread] [next in thread] 

List:       grass-dev
Subject:    Re: [GRASS-dev] How to calculate log() in v.db.update with SQLite backend?
From:       Markus Neteler <neteler () osgeo ! org>
Date:       2014-11-28 10:18:14
Message-ID: CALFmHhsasm=esh86JmkDjghUdKSCFF9EJFENOOqwJgpvX8N+yA () mail ! gmail ! com
[Download RAW message or body]

Hi,

On Thu, Nov 20, 2014 at 10:53 AM, Markus Neteler <neteler@osgeo.org> wrote:
...
> Trying with my locally modified  v.db.update
>
> GRASS 7.1.svn (nc_spm_08_grass7):~ > g.copy
> vect=precip_30ynormals,myprecip_30ynormals
>
> GRASS 7.1.svn (nc_spm_08_grass7):~ > v.db.addcolumn
> myprecip_30ynormals column="logjuly double precision"
>
> GRASS 7.1.svn (nc_spm_08_grass7):~ > v.db.update myprecip_30ynormals
> column="logjuly" qcolumn="log(jul)"
> sqliteextra=/home/neteler/software/sqlite_extensions/libsqlitefunctions.so
>
> GRASS 7.1.svn (nc_spm_08_grass7):~ > v.db.select myprecip_30ynormals
> columns=jul,logjuly
> jul|logjuly
> 132.842|4.88916045210132
> 127|4.84418708645859
> 124.206|4.82194147751127
> 104.648|4.65060233738593
> 98.298|4.58800368106618
> ...
>
> Works.

Submitted to trunk in r63238. Please test (tomorrow) also on Windows
if possible (the name will be something like libsqlitefunctions.dll
which you need to provide to v.db.select).

Markus
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
[prev in list] [next in list] [prev in thread] [next in thread]