Re: [GENERAL] How to get seq after insert

I think writing SQL as a portable as possible to cover eventual upgrades to
larger scale databases is a primary concern. The Selecting of a sequence is
more portable across various databases...

-----Original Message-----
From: Michael Davis <michael(dot)davis(at)tvguide(dot)com>
To: 'Brian' <signal(at)shreve(dot)net>; pgsql-general(at)postgreSQL(dot)org
<pgsql-general(at)postgreSQL(dot)org>
Date: Wednesday, April 14, 1999 4:37 PM
Subject: 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)
>
>