Re: mysql's last_insert_id

Поиск
Список
Период
Сортировка
От Bo Lorentsen
Тема Re: mysql's last_insert_id
Дата
Msg-id 1062049686.1925.1408.camel@localhost
обсуждение исходный текст
Ответ на mysql's last_insert_id  (Michal Adamczakk <pokryfka@artland.com.pl>)
Ответы Re: mysql's last_insert_id  (Dennis Björklund <db@zigo.dhs.org>)
Список pgsql-general
On Fri, 2003-08-22 at 22:03, Michal Adamczakk wrote:

> how to implement mysql's last_insert_id() ?
You will be able to use the "PQoidValue" function that returns the last
inserted row oid, just after an insert command.

Then if you want the newly inserted row you do something like this
"SELECT * FROM table_name WHERE oid=42", where 42 is the oid number
returned from the "PQoidValue".

Now ... I know that its possible to omit the oid's from large tables,
and then this method will not work anymore. What to do in this case
still eludes me (Anyone ?) :-)

/BL


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Replication Ideas
Следующее
От: Bo Lorentsen
Дата:
Сообщение: Re: 7.4b1 vs 7.3.4 performance