Re: Return the primary key of a newly inserted row?

From: John Tregea <john(at)debraneys(dot)com>
To: Alban Hertroys <alban(at)magproductions(dot)nl>
Cc: Scott Ribe <scott_ribe(at)killerbytes(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-27 00:46:21
Message-ID: 44A07FDD.8090701@debraneys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Thanks for the continued suggestions on this question. I will reply
again once it is implemented and working.

Kind regards

John

Alban Hertroys wrote:
> 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 ;)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Turner 2006-06-27 01:49:34 Re: RAID + PostgreSQL?
Previous Message Mischa Sandberg 2006-06-26 23:21:08 Re: list or regular expressions