Re: GetLastInsertID ?
От
Dave Cramer
Тема
Re: GetLastInsertID ?
Дата
Msg-id
1072993871.1662.43.camel@localhost.localdomain
Ответ на
Re: GetLastInsertID ? (Mike Nolan)
Список
Дерево обсуждения
GetLastInsertID ? Stephane Pinel <spinel@noos.fr>
Re: GetLastInsertID ? Dave Cramer <pg@fastcrypt.com>
Re: GetLastInsertID ? Oliver Elphick <olly@lfix.co.uk>
Re: GetLastInsertID ? Martijn van Oosterhout <kleptog@svana.org>
Re: GetLastInsertID ? Dennis Bjorklund <db@zigo.dhs.org>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Dave Cramer <pg@fastcrypt.com>
Re: GetLastInsertID ? Martin Marques <martin@bugs.unl.edu.ar>
Re: GetLastInsertID ? Martijn van Oosterhout <kleptog@svana.org>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Tom Lane <tgl@sss.pgh.pa.us>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Doug McNaught <doug@mcnaught.org>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Martijn van Oosterhout <kleptog@svana.org>
Re: GetLastInsertID ? Tom Lane <tgl@sss.pgh.pa.us>
Re: GetLastInsertID ? Stephane Pinel <spinel@noos.fr>
Yes, it will curval is the curval for *this* connection, not the current value for the sequence! Dave On Thu, 2004-01-01 at 16:37, Mike Nolan wrote: > > > the last inserted id in the table like we do with MySQL using the > > > GetLastInsertID ? > > > > > > My need is to get back the new id just after inserting. > > > > Use currval() after you have inserted. > > That will not necessarily tell you the last insertion, depending > upon how many other users there are doing inserts. > > For that matter, I'm not sure that the MySQL method works with multiple > users either. > -- > Mike Nolan > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Dave Cramer 519 939 0336 ICQ # 1467551
В списке pgsql-general по дате отправления
