Received: from netsystems.fr (du-fr1-0986.claranet.fr [212.43.203.224]) by hub.org (8.9.3/8.9.3) with SMTP id KAA76807 for ; Fri, 10 Dec 1999 10:42:01 -0500 (EST) (envelope-from eric@netsystems.fr) Received: (qmail 5026 invoked by uid 1000); 10 Dec 1999 15:46:42 -0000 Sender: eric@venus.fondation To: pgsql-sql@postgresql.org Subject: INSERT and SELECT Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit From: Eric BARROCA Date: 10 Dec 1999 16:46:42 +0100 Message-ID: <87n1riu7bx.fsf@venus.fondation> Lines: 24 X-Mailer: Gnus v5.6.45/XEmacs 21.1 - "Bryce Canyon" 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 :