Re: How I can read-back a serial value just inserted?

Поиск
Список
Период
Сортировка
От Devrim GUNDUZ
Тема Re: How I can read-back a serial value just inserted?
Дата
Msg-id 1169136366.3236.25.camel@laptop.gunduz.org
обсуждение исходный текст
Ответ на Re: How I can read-back a serial value just inserted?  (Russ Brown <pickscrape@gmail.com>)
Список pgsql-general
Hi,

On Thu, 2007-01-18 at 10:01 -0600, Russ Brown wrote:
> lastval's main benefit is in aiding the port of MySQL apps (being a
> drop-in replacement for LAST_INSERT_ID()). without lastval such ports
> can be really difficult.

I think one can also use INSERT/UPDATE...RETURNING that appeared in 8.2.

Regards,

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/




Вложения

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

Предыдущее
От: Russ Brown
Дата:
Сообщение: Re: How I can read-back a serial value just inserted?
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Ask about large database?