RE: [GENERAL] How to get seq after insert

The safest way is to select the nextval('seq_name') and then insert using
this value.

    -----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)