Received: from photon.skillbrokers.bg (root@[195.24.42.194]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA94272 for ; Fri, 10 Dec 1999 11:44:50 -0500 (EST) (envelope-from nmmm@nmmm.nu) Received: from niki (proton.skillbrokers.bg [195.24.42.206]) by photon.skillbrokers.bg (8.9.0/8.9.0) with SMTP id SAA19478; Fri, 10 Dec 1999 18:35:47 +0200 Message-ID: <002701bf432d$a8f549a0$ce2a18c3@skillbrokers.bg> From: "Nikolay Mijaylov" To: "Eric BARROCA" Cc: References: <87n1riu7bx.fsf@venus.fondation> Subject: Re: [SQL] INSERT and SELECT Date: Fri, 10 Dec 1999 18:43:15 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 As i know PgSQL support subqueryes only in Where part -------------------------------------------------------------- The reboots are for hardware upgrades! "http://www.nmmm.nu; ----- Original Message ----- From: Eric BARROCA To: Sent: ïåòúê, Äåêåìâðè 10, 1999 05:46 Subject: [SQL] INSERT and SELECT > Hi, > > I've tried this query with PostgreSQL, but it doesn't work. Could anyone > explain me why and what must I do to get the same result ? > Query example : "INSERT INTO table VALUES ( > (SELECT oid FROM membre WHERE email="toto@toto.com"), > "test");" > I get the error : "parse error near select". > > I've been searched in the manual and with deja.com but I haven't found > something about this. > This query works with mysql (and it's the only one query that works with > this RDBMS ;-) > > > Thanks, > > Éric. > > -- > Éric BARROCA | Logiciels Libres, Conception Intranet/Extranet, > E-Mail: eric@netsystems.fr | Sites Web dynamiques, Commerce électronique, > Tel: +33 (0)2 48 21 54 67 | Formations (Unix/Linux, Perl, etc.), Réseaux... > GSM: +33 (0)6 16 35 33 25 | NetSystems : > > ************