selecting the last record from a table

Поиск
Список
Период
Сортировка
От MT
Тема selecting the last record from a table
Дата
Msg-id 3DDA88DF.2080105@open2web.com
обсуждение исходный текст
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Dan Winslow"
Дата:
Сообщение: Update table with max occurance from another table
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: selecting the last record from a table