Re: INSERT question

>>>>> "Jason" == Jason Earl <jason(dot)earl(at)simplot(dot)com> writes:

Jason> Even better, however, is to use the functions nextval() and
Jason> currval() like so:

Jason> INSERT INTO parent_table (data) values ('some data');
Jason> INSERT INTO child_table (parent, more_data)
Jason> (currval('parent_table_p_key_seq'),
Jason> 'more data');

The above is probably the best for a pure-SQL way with the caveat
that it should be wrapped in a transaction or currval() may not be
what you expect; i.e., another client may add a row and you get a
value different from what you inserted.

roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375