Re: [GENERAL] How to get seq after insert]

[Bruce Momjian]

> On Wed, 14 Apr 1999, Michael Davis wrote:
> 
> > The safest way is to select the nextval('seq_name') and then insert using
> > this value.
> 
> I understand, I just thought something like, I do the insert, and then
> grab the value with:
> 
>  $insertid = $sth->{'insertid'};

The OID is returned from the insert.  Use that, or use it to look up the
field you want.

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