Return serial from insert

From: Rory Campbell-Lange <mail(at)campbell-lange(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Return serial from insert
Date: 2002-11-08 15:29:36
Message-ID: 20021108152936.GB15280@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I would like to return the autoincremented serial number resulting from
a new insert into a table, ideally as a result from the insert
statement.

Presumably this is the way to avoid race conditions between inserts into
the database, because if I do 1) insert then 2) get max sequence val, 2
might be wrong.

Thanks
Rory

--
Rory Campbell-Lange
<rory(at)campbell-lange(dot)net>
<www.campbell-lange.net>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Rod Kreisler 2002-11-08 15:49:46 Re: Return serial from insert
Previous Message Retzlaw Heinrich 2002-11-08 15:02:59 creating table with an encrypted filed