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

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Return the primary key of a newly inserted row?
Дата
Msg-id 44A000F9.6090107@magproductions.nl
обсуждение исходный текст
Ответ на Re: Return the primary key of a newly inserted row?  (Scott Ribe <scott_ribe@killerbytes.com>)
Ответы Re: Return the primary key of a newly inserted row?  (John Tregea <john@debraneys.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: initlocation on 8.0+
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: initlocation on 8.0+