[postgis-users] Problem with intersection from postgresql 8.0.7 to 8.1.3 win32

[René F. Viancos S.]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060216/de6fef95/attachment.html>