Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Return the primary key of a newly inserted row?
- From: Alban Hertroys <alban(at)magproductions(dot)nl>
- To: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
- Cc: John Tregea <john(at)debraneys(dot)com>, Kenneth Downs <ken(at)secdat(dot)com>, Tim Allen <tim(at)proximity(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
- Subject: Re: Return the primary key of a newly inserted row?
- Date: Mon, 26 Jun 2006 17:44:57 +0200
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(at)magproductions(dot)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 //
- Follow-Ups:
- Re: Return the primary key of a newly inserted row?
- From: John Tregea
- Re: Return the primary key of a newly inserted row?
- References:
- Re: Return the primary key of a newly inserted row?
- From: Scott Ribe
- Re: Return the primary key of a newly inserted row?
- Prev by Date: Re: initlocation on 8.0+
- Next by Date: Re: initlocation on 8.0+
- Previous by thread: Re: Return the primary key of a newly inserted row?
- Next by thread: Re: Return the primary key of a newly inserted row?
- Indexes: