Re: Multiple subquery with insert into command ?

Use the following:

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 in
(23,58);

http://www.sql-ex.ru/help/select11.php

> 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
querypossibility of postgresql ? 
 
> Thanks a lot in advance :)
> Seb
> 

Яндекс.Почта. Письма есть. Спама - нет. http://mail.yandex.ru/nospam/sign