Re: shorter way to get new value of serial?

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: shorter way to get new value of serial?
Дата
Msg-id 20051118180515.GB29354@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на shorter way to get new value of serial?  (Harald Armin Massa <haraldarminmassa@gmail.com>)
Список pgsql-general
On Fri, Nov 18, 2005 at 02:26:26PM +0100, Harald Armin Massa wrote:
> everything is fine. BUT: I feel that this a SO USUAL request (please, give
> me the new primary key of that just inserted beast), that there may be a
> simpler way, and I am just to blind to see.

See the currval() documents:

http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html

A
--
Andrew Sullivan  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
        --Dennis Ritchie

В списке pgsql-general по дате отправления:

Предыдущее
От: Csaba Nagy
Дата:
Сообщение: Re: How to debug a locked backend ?
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: How to debug a locked backend ?