RE: [GENERAL] How to get seq after insert

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'};


assuming field "insertid" was the one being updated by the sequence, but
that doenst seem to work.


>
>     -----Original Message-----
>     From:    Brian [SMTP:signal@shreve.net]
>     Sent:    Wednesday, April 14, 1999 2:59 PM
>     To:    pgsql-general@postgreSQL.org
>     Subject:    [GENERAL] How to get seq after insert
>
>
>     I have a sequence in a table that increments upon insert.  After
> doing the
>     insert, is their a way (function maybe?) to get the sequences value
>     without having to do another select?
>
>     Brian
>
>
>     -----------------------------------------------------
>     Brian Feeny (BF304)     signal@shreve.net
>     318-222-2638 x 109    http://www.shreve.net/~signal
>     Network Administrator   ShreveNet Inc. (ASN 11881)
>
>

-----------------------------------------------------
Brian Feeny (BF304)     signal@shreve.net
318-222-2638 x 109    http://www.shreve.net/~signal
Network Administrator   ShreveNet Inc. (ASN 11881)