Re: Return the primary key of a newly inserted row? - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Return the primary key of a newly inserted row?
Date
Msg-id 44A000F9.6090107@magproductions.nl
Whole thread Raw
In response to Re: Return the primary key of a newly inserted row?  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: Return the primary key of a newly inserted row?  (John Tregea <john@debraneys.com>)
List pgsql-general
Scott Ribe wrote:
>>You won't have duplicates[1], it's a sequence. It's its purpose.
>>
>>Now I may have missed something, I didn't follow this thread.
>
>
> Yes, what you quoted was more the intro. The actual question was how to find
> out what ids were generated during a sequence of insertions.

That's where you use currval ;)

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: initlocation on 8.0+
Next
From: Michael Fuhr
Date:
Subject: Re: initlocation on 8.0+