Re: selecting the last record from a table

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(at)open2web(dot)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