in reply to Re: (OT) Postgres Query
in thread (OT) Postgres Query

Ah, but that returns all accesses, not just the most recent. So if one object was accessed twice since another was accessed once, iterating through the rows would return two rows for the first object before returning any for the second. The goal is to have one row per object, accompanied by info from the last transaction affecting that object.
  • Comment on Re (Anonymous Monk ;-): Re: (OT) Postgres Query