Guys: I have a series of queries that looks for the most recent value associated with a given key. For example, consider the following query:
select max(timestamp), hash, most_recent(value) group by hash. Right now I do this by a hack: I grab max(timestamp * 100 + value), then I grab the value off the end of the computed maximum. Is there a smarter way of doing this? It seems like it would be a relatively common query. -- Adam J. O'Donnell, Ph.D. Immunet Corporation Cell: +1 (267) 251-0070
