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