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(at)shreve(dot)net]
Sent: Wednesday, April 14, 1999 2:59 PM
To: pgsql-general(at)postgreSQL(dot)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(at)shreve(dot)net
318-222-2638 x 109 http://www.shreve.net/~signal
Network Administrator ShreveNet Inc. (ASN 11881)