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