Re: selecting the last record from a table
От | Ericson Smith |
---|---|
Тема | Re: selecting the last record from a table |
Дата | |
Msg-id | 1037734374.1500.1.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: selecting the last record from a table (Doug McNaught <doug@mcnaught.org>) |
Список | pgsql-general |
You might want to get the sequence before you even do the insert... SELECT nextval('my_sequence') as id Then do the insert with the sequence and all other operations with the "id". Sure you might have a few holes in the sequence if you abort an insert, but this way you dont have to mess with OID's etc. - Ericson On Tue, 2002-11-19 at 14:07, Doug McNaught wrote: > MT <mt@open2web.com> writes: > > > I have a script that inserts a record into a table and increments the > > unique field using nextval('my_sequence'). My problem is once I have > > inserted the record, I'd like to select this same record and display > > it so that the user knows he has actually inserted the record. I'm > > wondering if there's a bit of sql to select the last record. > > SELECT * FROM mytable WHERE my_unique_field = currval('my_sequence'); > > -Doug > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org
В списке pgsql-general по дате отправления: