[SQL] Multiple subquery with insert into command ?
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
Re: [SQL] 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 query possibility of postgresql ? > Thanks a lot in advance :) > Seb > Яндекс.Почта. Письма есть. Спама - нет. http://mail.yandex.ru/nospam/sign -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Multiple subquery with insert into command ?
Thx a lot, problem resolved :) On Mon, Jun 7, 2010 at 6:59 PM, msi77 wrote: > 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 query possibility of postgresql > ? > > Thanks a lot in advance :) > > Seb > > > > Яндекс.Почта. Письма есть. Спама - нет. http://mail.yandex.ru/nospam/sign >
