'Re: [GRASS-user] sqrt sql'

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

List:       grass-user
Subject:    Re: [GRASS-user] sqrt sql
From:       Frank David <frank.david () geophom ! fr>
Date:       2019-03-08 13:11:05
Message-ID: 3c67a1da-ecfc-a157-342c-153faeab6deb () geophom ! fr
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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 <frank.david@geophom.fr 
> <mailto:frank.david@geophom.fr>> 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 <mailto:grass-user@lists.osgeo.org>
>     https://lists.osgeo.org/mailman/listinfo/grass-user
>

[Attachment #5 (text/html)]

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body bgcolor="#FFFFFF" text="#333333">
    <p>Thank you very much Vero !</p>
    <p>Frank<br>
    </p>
    <div class="moz-cite-prefix">Le 08/03/2019 à 11:10, Veronica Andreo
      a écrit :<br>
    </div>
    <blockquote type="cite"
cite="mid:CAAMki4E9tF6EFG8AQ4_01gjWr9C4gtx1CuOMJBUhHhukV0pVFw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="auto">Hi
        <div dir="auto"><br>
        </div>
        <div dir="auto"><span style="font-family:sans-serif">functionalities
            like sqrt() or log() are not available in base SQLite, then
            you have to install an extension</span><br>
        </div>
        <div dir="auto"><span style="font-family:sans-serif"><br>
          </span></div>
        <div dir="auto">See v.db.update manual page and this wiki: <a
            href="https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_Linux"
            moz-do-not-send="true">https://grasswiki.osgeo.org/wiki/Build_SQLite_extension_on_Linux</a></div>
  <div dir="auto"><br>
        </div>
        <div dir="auto">HTH,</div>
        <div dir="auto">Vero</div>
        <div dir="auto"><br>
        </div>
        <div dir="auto"><br>
        </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">El vie., 8 mar. 2019 05:22,
          Frank David &lt;<a href="mailto:frank.david@geophom.fr"
            moz-do-not-send="true">frank.david@geophom.fr</a>&gt;
          escribió:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
          <br>
          How Is it possible to calculate a sqrt from attribut fields to
          fill <br>
          another field, like :<br>
          <br>
          v.db.update map=myvector column=field2
          query_column=sqrt(field1)<br>
          <br>
          Or is there any trick ?<br>
          <br>
          Thank you<br>
          <br>
          Frank<br>
          _______________________________________________<br>
          grass-user mailing list<br>
          <a href="mailto:grass-user@lists.osgeo.org" target="_blank"
            rel="noreferrer" \
moz-do-not-send="true">grass-user@lists.osgeo.org</a><br>  <a \
href="https://lists.osgeo.org/mailman/listinfo/grass-user"  rel="noreferrer \
                noreferrer" target="_blank"
            moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/grass-user</a></blockquote>
  </div>
    </blockquote>
  </body>
</html>

[Attachment #6 (text/plain)]

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

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