Обсуждение: Obtaining the primary key of the record just inserted

Поиск

Список

Период

Сортировка

Obtaining the primary key of the record just inserted

От

"Oliveiros Cristina"

Дата:

08 ноября 2007 г., 13:50:28

Hello, All,

I have the need to know the primary key assigned to a record I've just INSERTed .

Is there an easy way to solve this ?

Similar to SQLServer's SELECT scope_identity() ; ?

Any help deeply appreciated

Best,

Oliveiros

Re: Obtaining the primary key of the record just inserted

От

Sean Davis

Дата:

08 ноября 2007 г., 14:02:00

Oliveiros Cristina wrote:
> Hello, All,
>
> I have the need to know the primary key assigned to a record I've just
> INSERTed .
>
> Is there an easy way to solve this ?
>
> Similar to SQLServer's  SELECT scope_identity() ; ?
>
> Any help deeply appreciated
Is the primary key a SERIAL column?

Sean

Re: Obtaining the primary key of the record just inserted

От

Hans-Peter Oeri

Дата:

08 ноября 2007 г., 15:27:40

Hi!

Oliveiros Cristina wrote:

I have the need to know the primary key assigned to a record I've just INSERTed .
Is there an easy way to solve this ?

I prefer:
INSERT INTO [...] RETURNING id;

HPO

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Obtaining the primary key of the record just inserted

Obtaining the primary key of the record just inserted

Re: Obtaining the primary key of the record just inserted

Re: Obtaining the primary key of the record just inserted