Hello, In your from clause, your table is aliases as part_1 and not part1.
Hugues laurent <[email protected]> a écrit : Hello, I have 2 tables : one points and one surface. I would like intersects the geometries. I write the query but i have an error message : -------------------------- CREATE TABLE example_intersections_a AS (SELECT ST_Intersection (part1.geom, part2.geom)FROM fra_adm0 AS part_1,france_merge_pts1 AS part2 WHERE ST_Intersects(part1.geom, part_2.geom)); ALTER TABLE example_intersections_a ADD COLUMN id SERIAL; ALTER TABLE example_intersections_a ADD PRIMARY KEY (id); ------------------------- Error message : ERREUR: entrée manquante de la clause FROM pour la table « part1 » LINE 1: ...ample_intersections_a AS (SELECT ST_Intersection (part1.geom... ^ ********** Erreur ********** ERREUR: entrée manquante de la clause FROM pour la table « part1 » État SQL :42P01 Caractère : 66 COuld you tell me where is the error? Thanks. -- View this message in context: http://postgis.17.x6.nabble.com/ST-intersects-error-message-tp5005029.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
