On Wed, Jan 8, 2014 at 10:09 AM, Francisco Olarte <fola...@peoplecall.com>wrote:
> 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 > Hi Francisco, My apologies, I was not completely clear. I will not know any of the columns in advance. The most recent insert is the result of user input from a web form, so I won't know what project or what user generated the last insert. That was why I wandered if that information was stored anywhere in the system. > > 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. >
