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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/grass-user > _______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user