Re: mysql's last_insert_id

Поиск
Список
Период
Сортировка
От Stuart
Тема Re: mysql's last_insert_id
Дата
Msg-id 3F4D24C7.8040000@blueyonder.co.uk
обсуждение исходный текст
Ответ на mysql's last_insert_id  (Michal Adamczakk <pokryfka@artland.com.pl>)
Список pgsql-general
Michal Adamczakk wrote:

> hi,
>
> how to implement mysql's last_insert_id() ?
>
> i know that seqences and oids are great.
> the one thing i miss is that they are not session specific.
>
> i mean selecting last_value from seqence can give me a value which was
> inserted by a different user.
>
> regards
> Michal
>

The currval('seq_name') returns the last for the specific connection,
not the last returned of any
hth,
- Stuart



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

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: postgresql not using index even though it's faster
Следующее
От: elein
Дата:
Сообщение: Clarifying File System Syncs