Re: [SQL] Another nut to crack with insertion into tables... *sigh*

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'