[postgis-users] Error in simple SQL

[Paul Ramsey]

somehow you have odd geometries in your geometry columns...

 select gid from quadras_poligono where not st_isvalid(the_geom);
 select gid from bairros_poligono where not st_isvalid(the_geom);

P

On Tue, Apr 22, 2008 at 8:18 AM, George R. C. Silva
<georger.silva at gmail.com> wrote:
> Hello everyone.
>
>  Am i doing something wrong? In pg 8.2 and pgis 1.2 this query worked...
>
>  select * from quadras_poligono, bairros_poligono where
> ST_intersects(bairros_poligono.the_geom,st_centroid(quadras_poligono.the_geom))
> and bairros_poligono.codbairro = 1;
>
>  now this doenst work. gives me this error. i dont know if it worked before
> or am i confusing with something else.
>  heres the error.
>
>  NOTICE:  IllegalArgumentException: Number of points must be 0 or >3
>
>  ERROR:  POSTGIS2GEOS conversion failed
>
>  what can i do for this to work?
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>