selecting the last record from a table

From: MT <mt(at)open2web(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: selecting the last record from a table
Date: 2002-11-19 18:54:23
Message-ID: 3DDA88DF.2080105@open2web.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks for your help,

Mark Tessier

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-11-19 19:07:52 Re: selecting the last record from a table
Previous Message Dan Winslow 2002-11-19 18:27:52 Update table with max occurance from another table