Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.8.8) with ESMTP id JAA05262 for ; Mon, 28 Sep 1998 09:54:50 -0400 (EDT) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id PAA14583; Mon, 28 Sep 1998 15:54:42 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zNfEA-0001Jr-00; Mon, 28 Sep 1998 15:28:42 +0000 Date: Mon, 28 Sep 1998 15:35:27 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <7649.980928@bo.nettuno.it> To: "PostgreSQL SQL Mailing List" , "Gemeinschaft Studienarbeit Datenbanken" Subject: Re: [SQL] Another nut to crack with insertion into tables... *sigh* References: <199809272146.1239275.6@onyx> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello Gemeinschaft, domenica, 27 settembre 98, you wrote: GSD> insert into Rollenspiel GSD> (Name, HerstellerID, Erscheinungsdatum, GSD> Bestellnummer, Preisempfehlung, GSD> Beschreibung, GSD> Computertyp, Datentraegertyp, GSD> System, AnzahlCharaktere, Typ, GSD> Cluebook, SpielstandEditor) GSD> values GSD> ('Might & Magic I', (select HerstellerNummer from Hersteller GSD> where Name like '%Blueborg%'), '17.03.1986', GSD> 'role01', '29,50', GSD> '{"Einfach irgendeine Beschreibung halt..."}', GSD> '{"PC", "Mac", "c64", "Atari"}', '{"Diskette", "CD"}', GSD> 'Freies System', 6, 'Fantasy', GSD> '{"Solution to Might & Magic Series", "The Might & Magic I Solution"}', GSD> '{"http://www.mightandmagic.de/I/editors.html"}'); GSD> ERROR: parser: parse error at or near "select" GSD> The question is: why? Actually, you can't assign the result of a subquery to a column, This is a TODO item: * Allow subqueries in target list Jose'