Re: Value of serial data type after insert.

#1

On Wed, Nov 10, 2004 at 02:34:22PM -0500, Ernest Kim wrote:

Quote:

I was wondering if there was a way to get the value of serial data
type after an insert.

Use currval():

http://www.postgresql.org/docs/7.4/s...-sequence.html

Race condtions aren't a problem:

"Notice that because this is returning a session-local value, it
gives a predictable answer even if other sessions are executing
nextval meanwhile."

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Value of serial data type after insert.

comp.databases.postgresql.general comp.databases.postgresql.general

Re: Value of serial data type after insert. - 11-13-2004 , 11:29 PM