Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.8.8/8.8.8) with ESMTP id KAA06023 for ; Mon, 28 Sep 1998 10:02:48 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA20076; Mon, 28 Sep 1998 10:02:10 -0400 (EDT) To: "Gemeinschaft Studienarbeit Datenbanken" cc: pgsql-sql@hub.org Subject: Re: Another nut to crack with insertion into tables... *sigh* In-reply-to: Your message of Sun, 27 Sep 1998 23:00:21 -0400 (EDT) <199809280300.XAA18545@hub.org> Date: Mon, 28 Sep 1998 10:02:10 -0400 Message-ID: <20074.906991330@sss.pgh.pa.us> From: Tom Lane I dunno about arrays, but this one I think I can answer: > insert into Rollenspiel > (Name, HerstellerID, Erscheinungsdatum, > Bestellnummer, Preisempfehlung, > Beschreibung, > Computertyp, Datentraegertyp, > System, AnzahlCharaktere, Typ, > Cluebook, SpielstandEditor) > values > ('Might & Magic I', (select HerstellerNummer from Hersteller > where Name like '%Blueborg%'), '17.03.1986', > 'role01', '29,50', > '{"Einfach irgendeine Beschreibung halt..."}', > '{"PC", "Mac", "c64", "Atari"}', '{"Diskette", "CD"}', > 'Freies System', 6, 'Fantasy', > '{"Solution to Might & Magic Series", "The Might & Magic I Solution"}', > '{"http://www.mightandmagic.de/I/editors.html"}'); > ERROR: parser: parse error at or near "select" I believe sub-selects are currently only supported in WHERE clauses. Supporting them elsewhere is on the TODO list for a future release (no, 6.4 won't have it). In the meantime you'll have to read back the result of the sub-select and include it in the text of the INSERT. (I'm not sure whether the SQL spec allows a select in an INSERT like this anyway. What happens if the sub-select returns no tuples, or more than one tuple?) regards, tom lane