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: 2006-06-26 15:44:57
Message-ID: 44A000F9.6090107@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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 //

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-06-26 15:47:56 Re: initlocation on 8.0+
Previous Message Scott Marlowe 2006-06-26 15:44:04 Re: initlocation on 8.0+