[GRASS-user] v.univar column type in SQLite

[Patricio Toledo]

Dear List 

I am working in DEBIAN lenny with a backported grass64 and i am experiencing
problems with varios vector modules which make use of v.univar (or v.db.univar
or v.univar.sh) in connection with SQLite databases. 

The question is: which column type v.univar supports, as a table created with

CREATE TABLE master (id INTEGER, value NUMERIC);

or 

CREATE TABLE master (id INTEGER, value DOUBLE PRECISION);

or 

CREATE TABLE master (id INTEGER, value INTEGER);

fails after a command like this:

    $ v.db.connect map=test data=/path/test.db driver=sqlite lay=1 table=master
cat=id
    $ v.univar map=test column=value
WARNING: Incompatible vector type(s) specified, only number of features,
         minimum, maximum and range can be calculated
ERROR: Column type not supported

I have searched into .h files but it seems that INTEGER, NUMERIC and DOUBLE
PRECISION are indeed supported (there is no problem if the vector is reconnected
with a DBF table).

am i doing something wrong?

Regards