[GRASS-user] sql and postgis

[Hamish]

Gustavo Martinez wrote:
> I am using GRASS 6.3 RC1 compiled from source. I have a big table (2 million 
> points) in Postgresql/Postgis that I can map with v.external. The problem is 
> when I try to select a subset of the data. I am using gis.m and when I run 
> the command:
> 
> d.vect map=monitoreo at PERMANENT color=0:0:0 lcolor=0:0:0 fcolor=170:170:170 
> display=shape type=point icon=basic/circle size=5 layer=1 lsize=8 xref=left 
> yref=center llayer=1 {where=vel<4}
> 
> I get the following error:
> 
> ERROR 1: ERROR:  error de sintaxis en o cerca de «FROM»
> LINE 1: SELECT  FROM monitoreo WHERE vel<4
>                         ^
> 
> DBMI-OGR driver error:
> Cannot select: 
> SELECT  FROM monitoreo WHERE vel<4
> 
> Any clues?



> LINE 1: SELECT  FROM monitoreo WHERE vel<4
               ^^^^

Somehow it is losing the '*'. The SQL query should look like:

  SELECT * FROM monitoreo WHERE vel<4

why? I don't know..


Hamish


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com