Re: [sqlite] String interning using foreign keys: How to write anINSERT trigger?

[Igor Tandetnik]

Dan Bishop wrote:
>   -- The statement below is invalid syntax.
>   INSERT INTO Emails (
>      MessageID,
>      (SELECT ID FROM Addresses WHERE Address=FromAddr),
>      (SELECT ID FROM Addresses WHERE Address=ToAddr)
>   )

INSERT INTO Emails values (
      MessageID,
      (SELECT ID FROM Addresses WHERE Address=FromAddr),
      (SELECT ID FROM Addresses WHERE Address=ToAddr))

or

INSERT INTO Emails
select MessageID,
    (SELECT ID FROM Addresses WHERE Address=FromAddr),
    (SELECT ID FROM Addresses WHERE Address=ToAddr)

-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users