[GRASS-user] sqlbuilder (SELECT)

[Vincent Bain]

Whoops, sorry for the noise. I give an auto-reply (may it help ) :

working on a new Location/mapset, I forgot to switch db driver to sth
else than dbf. Modulo seems not to be supported by the dbf driver (it is
a matching operator, dedicated to character fields).
Back to pg driver, the statement is valid.

Bye,
Vincent.


Le mercredi 23 mars 2011 à 08:26 +0100, Vincent Bain a écrit :
> Hi list,
> trying to manage a vector attribute table, I explored the sqlbuilder
> menu (py gui, grass64, quite a bit old svn version -- say 2 months).
> 
> My query contains a modulus condition, so I guess I can use the "%"
> button, but the query is qualified unvalid.
> 
> e.g I need to extract "z" value every 100 m from a contour line "topo"
> vector map.
> This statement :
> 
>         SELECT z FROM topo WHERE z % 100 = 0
> 
> returns this error message :
> 
>         SQL statement is not valid.
>         dbmi: Protocol error
>         
> 
> Any idea of what I am doing wrong ?
> Thank you,
> 
> Vincent.
> 
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>