Dear all, maybe a stupid question, but: I have a table that is ordered like this:
user_id|timestamp|event 1 |0:1 |event_a 1 |0:2 |event_b 2 |0:1 |event_b 2 |0:3 |event_c 2 |0:4 |event_b 3 |0:1 |event_a and I would like to number them according to their timestamps like this: user_id|timestamp|event |order 1 |0:1 |event_a |1 1 |0:2 |event_b |2 2 |0:1 |event_b |1 2 |0:3 |event_c |2 2 |0:4 |event_b |3 3 |0:1 |event_a |1 How would I do this with an UPDATE statement (e.g.) in pgsql? Thanks in advance for any hint Jan -- NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie! Jetzt informieren: http://www.gmx.net/de/go/freephone -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql