Received: from onyx (ONyx.Floppy.ORG [195.222.226.249]) by hub.org (8.8.8/8.8.8) with SMTP id PAA18838 for ; Sun, 27 Sep 1998 15:45:44 -0400 (EDT) (envelope-from oodbms@floppy.org) Received: from onyx.floppy.org (onyx.floppy.org [195.222.226.249] ) by onyx (Hethmon Brothers Smtpd) ; Sun, 27 Sep 1998 21:46:12 +0100 Message-Id: <199809272146.1239275.6@onyx> From: "Gemeinschaft Studienarbeit Datenbanken" To: "PostgreSQL SQL Mailing List" Date: Sun, 27 Sep 1998 21:46:12 +0100 Reply-To: "Gemeinschaft Studienarbeit Datenbanken" Priority: Normal X-Mailer: PMMail 1.96a For OS/2 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: Another nut to crack with insertion into tables... *sigh* 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" The question is: why? spiele=> select HerstellerNummer from Hersteller; herstellernummer ---------------- 1 2 30 31 32 4 5 6 7 8 66 70 99 17 88 (15 rows) Doing this from psql plainly yields the wanted result: spiele=> select HerstellerNummer from Hersteller where Name like '%Blueborg%'; herstellernummer ---------------- 7 (1 row) Pointers to FAQs, solutions, help, donuts greatly appreciated ;-)