| From: | reyman <reyman64(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Multiple subquery with insert into command ? |
| Date: | 2010-06-07 16:22:55 |
| Message-ID: | AANLkTin0ZdbpNswGyO5dkS7cVH2euTpjulqN2aekyWCL@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | msi77 | 2010-06-07 16:59:44 | Re: Multiple subquery with insert into command ? |
| Previous Message | Nilesh Govindarajan | 2010-06-06 16:34:16 | Re: Difference between these two queries ? |