Hi,
I need to display log events (again).
The log is simply like this
log ( log_id serial primary key, create_ts timestamp default
localtimestamp, object_id, state_id, ....... )
It records the state of objects and when and what happend to to change
this state.
I'd like to get a list that shows the current state at any point of time
and the state of the last event before regarding the current object_id.
The tricky bit is that both states should appear in the same row for
every row.
Help?
:)