Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 6A0A5B5DD2D for ; Wed, 2 Nov 2011 13:43:12 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 43554-04-3 for ; Wed, 2 Nov 2011 16:43:06 +0000 (UTC) X-Greylist: delayed 00:06:37.036894 by SQLgrey-1.8.0-rc2 Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id 32548B5DD27 for ; Wed, 2 Nov 2011 13:43:04 -0300 (ADT) Received: (qmail 19299 invoked by uid 0); 2 Nov 2011 16:36:22 -0000 Received: from 62.218.164.126 by www028.gmx.net with HTTP; Wed, 02 Nov 2011 17:36:19 +0100 (CET) Content-Type: text/plain; charset="utf-8" Date: Wed, 02 Nov 2011 17:36:19 +0100 From: "Jan Peters" Message-ID: <20111102163619.135780@gmx.net> MIME-Version: 1.0 Subject: Number timestamped rows To: pgsql-sql@postgresql.org X-Authenticated: #16900582 X-Flags: 0001 X-Mailer: WWW-Mail 6100 (Global Message Exchange) X-Priority: 3 X-Provags-ID: V01U2FsdGVkX1/MSl8Hfp3Mhrlp1EiMsuQP81bvj1BmAAjD+5cSqY Pw0EtBA+rA0VWizvmGzaXq9Ohb6wV806D+Ig== Content-Transfer-Encoding: 8bit X-GMX-UID: ukmHB0JyQEV/ftHXaHRpHjJCNzg2NcIB X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201111/3 X-Sequence-Number: 35976 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