[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_as

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_i

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.na