Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 20B4D633408 for ; Mon, 7 Jun 2010 13:59:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 29283-04 for ; Mon, 7 Jun 2010 16:59:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from forward13.mail.yandex.net (forward13.mail.yandex.net [95.108.130.120]) by mail.postgresql.org (Postfix) with ESMTP id 4313163313D for ; Mon, 7 Jun 2010 13:59:47 -0300 (ADT) Received: from web139.yandex.ru (web139.yandex.ru [95.108.130.7]) by forward13.mail.yandex.net (Yandex) with ESMTP id 598E41080474; Mon, 7 Jun 2010 20:59:45 +0400 (MSD) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1275929985; bh=PFWT5D1Fy6AOxMGsKdsC1X+Fk/uFzu7wrYYwZLUnQS4=; h=From:To:In-Reply-To:References:Subject:MIME-Version:Message-Id: Date:Content-Transfer-Encoding:Content-Type; b=K9JieVclMZ/cJLtgl3dY/wnGalJma8qQpT7c9fPj22r3zo5LcLtZqAJfLf7nzWA2F PcqTeIUmyP9OukdzBLCfMIPpQV1Epa6E5UQtq4l1nar9vx5JQPJc8dTftk3sHzvuk1 zsDb4bSdeh/VS/t81DEK71QvKv3Brim7cbb4bg54= Received: from localhost (localhost.localdomain [127.0.0.1]) by web139.yandex.ru (Yandex) with ESMTP id 56B92198803A; Mon, 7 Jun 2010 20:59:45 +0400 (MSD) X-Yandex-Spam: 1 X-Yandex-Front: web139.yandex.ru X-Yandex-TimeMark: 1275929985 Received: from user-17.81.118.217.in-addr.arpa (user-17.81.118.217.in-addr.arpa [217.118.81.17]) by mail.yandex.ru with HTTP; Mon, 07 Jun 2010 20:59:44 +0400 From: msi77 To: reyman ,pgsql-sql@postgresql.org In-Reply-To: References: Subject: Re: Multiple subquery with insert into command ? MIME-Version: 1.0 Message-Id: <150391275929985@web139.yandex.ru> Date: Mon, 07 Jun 2010 20:59:44 +0400 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=utf-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=4.594 tagged_above=-5 required=5 tests=BAYES_50=0.8, RCVD_HAS_FROM_USER=1.677, RCVD_IN_BL_SPAMCOP_NET=1.347, RCVD_IN_SORBS_WEB=0.77 X-Spam-Level: **** X-Archive-Number: 201006/28 X-Sequence-Number: 34219 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