[GRASS5] [bug #3573] (grass) v.db.select - don't force all the input columns to the output datable

GRASS GIS GRASS GIS developer
1

this bug's URL: http://intevation.de/rt/webrt?serial_num=3573
-------------------------------------------------------------------------

Subject: v.db.select - don't force all the input columns to the output datable

Platform: GNU/Linux/i386
grass obtained from: CVS
grass binary for platform: Compiled from Sources
GRASS Version: cvs 23.08.05

Please let me choose whether I want all the input columns to be present in the output datatable or only those selected by me.

Below I'm trying to omit importing the x and y columns to output datatable (I want to use them only for coordinates). But this is recognized as an "error".

v.db.select -c map=wejscie column=cat,rast_val,x,y | v.in.ascii output=grd_faults_pt_nocat_addcat_asc columns='CAT integer, WYS double' x=3 y=4 cat=1

Maximum input row length: 44
Maximum number of columns: 4
Minimum number of columns: 4
column: 1 type: integer
column: 2 type: double
column: 3 type: double
column: 4 type: double
ERROR: Number of columns defined (2) does not match number of columns (4)
       in input.

Maciek

-------------------------------------------- Managed by Request Tracker

2

On Thu, Aug 25, 2005 at 02:40:31PM +0200, Request Tracker wrote:

this bug's URL: http://intevation.de/rt/webrt?serial_num=3573
-------------------------------------------------------------------------

Subject: v.db.select - don't force all the input columns to the output datable

Platform: GNU/Linux/i386
grass obtained from: CVS
grass binary for platform: Compiled from Sources
GRASS Version: cvs 23.08.05

Please let me choose whether I want all the input columns to be present in the output datatable or only those selected by me.

Below I'm trying to omit importing the x and y columns to output datatable (I want to use them only for coordinates). But this is recognized as an "error".

v.db.select -c map=wejscie column=cat,rast_val,x,y | v.in.ascii output=grd_faults_pt_nocat_addcat_asc columns='CAT integer, WYS double' x=3 y=4 cat=1

Maximum input row length: 44
Maximum number of columns: 4
Minimum number of columns: 4
column: 1 type: integer
column: 2 type: double
column: 3 type: double
column: 4 type: double
ERROR: Number of columns defined (2) does not match number of columns (4)
       in input.

Maciek

-------------------------------------------- Managed by Request Tracker

Maciek,

you could put a

| cut -d'<delimiter>' -f<field>[,<field>] in between.

Markus