[GRASS-dev] v.db.update: any reason to keep both value and qcolumn parameter ?

Moritz Lennert mlennert at club.worldonline.be
Tue Sep 30 04:58:13 EDT 2008


In v.db.update we currently have:

#%option
#% key: value
#% type: string
#% description: Value to update the column with, can be (combination of) 
other column(s)
#% required : no
#%end
#%option
#% key: qcolumn
#% type: string
#% description: Column to query
#% required : no
#%end


'qcolumn' was added in a later stage, AFAIK mostly because of a 
misunderstanding of 'value'. As said in the help text, value can be 
either a value, a name of another column or a combination of other 
columns, so it already comprises qcolumn.

However, in its current version (since rev 23578), value is now adapted 
according to column type, which means that you cannot use column 
operations on varchar columns (e.g. concatenation).

So, we should either:

- change the doc to reflect that value should only be a nominal value, or
- go back to the original, i.e. no qcolumn and no type checking for 
value, so that it's up to the user to use correct quoting

Any preferences ?

Moritz


More information about the grass-dev mailing list