Hi Nelson: On Wed, Jan 8, 2014 at 4:54 PM, Nelson Green <nelsongree...@gmail.com> wrote: > 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?
SELECT MAX(sequence) FROM project_log_table WHERE person_num=427 AND project_num=15 If it's a PK it should have an index and I believe it will be quite fast. AAMOF, you could even build the above with max+1 into the insert query for a new entry and have the values returned using a RETURNING clause. Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
