Re: GetLastInsertID ?
От | Dave Cramer |
---|---|
Тема | Re: GetLastInsertID ? |
Дата | |
Msg-id | 1072993871.1662.43.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: GetLastInsertID ? (Mike Nolan <nolan@gw.tssi.com>) |
Ответы |
Re: GetLastInsertID ?
|
Список | pgsql-general |
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 по дате отправления: