[GRASS5] Trouble with d.what.v.pg

Moritz Lennert mlennert at club.worldonline.be
Mon Mar 10 04:15:05 EST 2003


> I'm trying to run d.what.v.pg in 5.0.2 CVS head in the command line mode.
> It fails with an error if I select a text column from the database.
>
>
> Executing
> SELECT * from POLBNDA_area where nam=8222
> --------------------
> Error: select Postgres:ERROR: Unable to identify an operator '=' for types
> 'text' and 'integer'
> You will have to retype this query using an explicit cast
>
>
>
> If I select a numeric column, I get no error but also get no results: it
> returns "0 rows selected". It looks like buildPg.c is assigning the
> category value from dig_cats to the variable that is supposed to hold the
> search results. Does anyone know how this is supposed to work?

If nam is text, the condition in the query should be: nam='8222'

Moritz




More information about the grass-dev mailing list