Last inserted row id with complex PK

Поиск
Список
Период
Сортировка
От Nelson Green
Тема Last inserted row id with complex PK
Дата
Msg-id CAGo-KZkErWMrRutaBP8TGQUfCCYi_bnqfvwoomqZqUGCD9z4bA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Last inserted row id with complex PK
Re: Last inserted row id with complex PK
Re: Last inserted row id with complex PK
Список pgsql-general
I have a projects log table with a three column PK, project_num, person_num, and sequence, where each new entry for a project/person combination increments the sequence, which is not an auto incrementing sequence. Is there any way to retrieve the last entry to the table? For instance, if the last entry for person 427 on project 15 was sequence number 125, is that information available to me anywhere?

Thanks,
Nelson

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

Предыдущее
От: gator_ml@yahoo.de
Дата:
Сообщение: Re: Consistent file-level backup of pg data directory
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: Last inserted row id with complex PK