Hello guys ! I have problem with my query, i want to use the multiple insert possibility of pgsql...
INSERT INTO umzintersect (intersection,umz00_id,pop, comm_id, name_asci) (SELECT intersection(umz_project.the_geom, lau2.the_geom), umz_project.umz00_id, umz_project.pop, lau2.comm_id, lau2.name_asci FROM umz_project, lau2,big_umz WHERE umz_project.umz00_id = big_umz.umz00_id AND umz_project.the_geom && lau2.the_geom AND umz_project.umz00_id = 23), (SELECT intersection(umz_project.the_geom, lau2.the_geom), umz_project.umz00_id, umz_project.pop, lau2.comm_id, lau2.name_asci FROM umz_project, lau2,big_umz WHERE umz_project.umz00_id = big_umz.umz00_id AND umz_project.the_geom && lau2.the_geom AND umz_project.umz00_id = 58); I have this error code : ********** Erreur ********** ERREUR: erreur de syntaxe sur ou près de « , » État SQL :42601 Caractère : 353 I don't understand where is my error ... With only one select, the query run, but with two, i have this error.. Perhaps insert into with multiple subquery is impossible ? So, how can i do this query without loose the GREAT multi query possibility of postgresql ? Thanks a lot in advance :) Seb
