Thx a lot, problem resolved :) On Mon, Jun 7, 2010 at 6:59 PM, msi77 <ms...@yandex.ru> 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 >
