How to get seq after insert

From: Brian <signal(at)shreve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: How to get seq after insert
Date: 1999-04-14 20:58:53
Message-ID: Pine.LNX.4.10.9904141557280.2921-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)shreve(dot)net
318-222-2638 x 109 http://www.shreve.net/~signal
Network Administrator ShreveNet Inc. (ASN 11881)

Browse pgsql-general by date

  From Date Subject
Next Message Bryan White 1999-04-14 21:31:44 Regression test core dumps
Previous Message Karl DeBisschop 1999-04-14 19:29:25 Re: [GENERAL] user-defined aggreaget functions