[GRASS5] v.reclass.pg

GRASS GRASS developer
1

Trying to run v.reclass.pg on the command line with

v.reclass.pg -s sql=recl.sql input=world2 output=test type=area

and recl.sql containing a simple statement like:

select distinct grass_id
from categories
where valeur > 55

I get the following error message and a segmentation fault :

PQgetvalue: ERROR! field number 1 is out of range 0..0

Can someone tell me what this means ?

Moritz

----------------------------------------
If you want to unsubscribe from GRASS Development Team mailing list write to:
minordomo@geog.uni-hannover.de with
subject 'unsubscribe grass5'

2

I think the problem is that sql with distinct clause
differs. I would try select distinct on grass_id
grass_id from .. so on. syntacsys changed in postgres
7.0 with this command.
--alex

--- mlennert@club.worldonline.be wrote:

Trying to run v.reclass.pg on the command line with

v.reclass.pg -s sql=recl.sql input=world2
output=test type=area

and recl.sql containing a simple statement like:

select distinct grass_id
from categories
where valeur > 55

I get the following error message and a segmentation
fault :

PQgetvalue: ERROR! field number 1 is out of range
0..0

Can someone tell me what this means ?

Moritz

----------------------------------------
If you want to unsubscribe from GRASS Development
Team mailing list write to:
minordomo@geog.uni-hannover.de with
subject 'unsubscribe grass5'

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

----------------------------------------
If you want to unsubscribe from GRASS Development Team mailing list write to:
minordomo@geog.uni-hannover.de with
subject 'unsubscribe grass5'