> Obviously, someone did because they tried the code and it didn't work. 
> At least the new code is closer to valid, though less clear.  It is at
> least a valid snippet, which the previous version was not.

OK, I changed it to more pseudocode:

    new_id = output of "SELECT nextval('person_id_seq')"
    INSERT INTO person (id, name) VALUES (new_id, 'Blaise Pascal');

and

    INSERT INTO person (name) VALUES ('Blaise Pascal'); 
    new_id = output of "SELECT currval('person_id_seq')";


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to