|5/10/2009 4:15:16 PM||Leo||Ben -- when you say falling over -- what sort of error are you getting?
|5/5/2009 1:01:13 AM||Ben||Hi Regina,
I created two layers in QGIS that had an overlap similar to your diagrams, then I imported them into two separate tables and then ran your sql verbatim. I think it kept falling over at the ST_Intersection(b,p).
|4/5/2009 1:58:31 AM||Regina||Ben,
Are you using the table name or the geometry name. Here is a simple exercise
SELECT ST_Intersection(ST_GeomFromText('LINESTRING(1 2, 3 4)'), ST_GeomFromText('POINT(1 2)'));
If you are using a table -- you statement should look like
SELECt ST_Intersection(table1.the_geom, table2.the_geom) As theint
FROM table1 INNER JOIN table2 ON ST_Intersects(table1.the_geom, table2.the_geom)
|4/1/2009 8:49:43 PM||ben davies||Hello,
I have attempted to run your example using PostgreSQL 8.3 and PostGIS 1.3.5 and get the following error ...
ERROR: function st_intersection(table_1, table_2) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Would you be able to tell me what the possible cause of this is.