[postgis-users] Problem with intersection from postgresql 8.0.7 to8.1.3 win32

[René F. Viancos S.]

yes, the srid's are the same, and the geometry is the same.

2006/2/16, Bruce Rindahl <rindahl at lrcwe.com>:
>
>  Has the srid been set for both geometries and are they the same?
>
>
>
> -----Original Message-----
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *René F.
> Viancos S.
> *Sent:* Thursday, February 16, 2006 3:33 PM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] Problem with intersection from postgresql 8.0.7
> to8.1.3 win32
>
>
>
> Dear users
>
> i have the following SQL sentence that work's fine with postgreSQL 8.0.7,
> win32, and PostGIS
>
> SELECT DISTINCT(intersection((SELECT collect(the_geom) FROM ejes_13
> WHERE nombre = 'BALMACEDA' AND nom_com1 = 'PUENTE ALTO'),(SELECT
> collect(the_geom) FROM ejes_13 WHERE nombre = 'EYZAGUIRRE' AND
> nom_com1 = 'PUENTE ALTO'))) FROM ejes_13 WHERE (nombre = 'BALMACEDA'
> OR nombre = 'EYZAGUIRRE') AND nom_com1 = 'PUENTE ALTO';
>
> this sql sentence give the point for the intersection of two streets,
> where "ejes_13" is the table with the street geometry, "nombre" is the field
> with the name of the street, and "nom_com1" is the field with the town name.
>
>
> when i run this sentence in postgreSQL 8.1.3, win32, and PostGIS, the data
> engine gives me the following error.
>
> ERROR: GEOS Intersection() threw an error!
>
> does somebody any ideas about this.....
>
> Regards
>
>
> --
> René F. Viáncos S.
> Director de Geomática y TIC
> Vicerrectoría de Investigación y Desarrollo
> Universidad de Chile
> Tel (56-2) 632 62 09
> Cel (56 9) 933 72 66
> rviancos at uchile.cl
> rviancos at gmail.com
> www.investigacion.uchile.cl
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>


--
René F. Viáncos S.
Director de Geomática y TIC
Vicerrectoría de Investigación y Desarrollo
Universidad de Chile
Tel (56-2) 632 62 09
Cel (56 9) 933 72 66
rviancos at uchile.cl
rviancos at gmail.com
www.investigacion.uchile.cl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060216/16d4c48a/attachment.html>