Thread: Multiple subquery with insert into command ?
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 />
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
Thx a lot, problem resolved :)
On Mon, Jun 7, 2010 at 6:59 PM, msi77 <msi77@yandex.ru> wrote:
Use the following: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);
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
http://www.sql-ex.ru/help/select11.phpЯндекс.Почта. Письма есть. Спама - нет. http://mail.yandex.ru/nospam/sign
> 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
>