From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Number timestamped rows
Date: 8 Nov 2011 09:36:12 GMT
Message-ID: <j9at6c$7ro$2@reversiblemaps.ath.cx> (raw)
References: <20111102163619.135780@gmx.net>
On 2011-11-02, Jan Peters <petersjan@gmx.at> wrote:
> Dear all,
> maybe a stupid question, but: I have a table that is ordered like this:
>
Tables aren't ordered. Sometimes they may seem to be ordered,
but they seldom stay that way for long.
> and I would like to number them according to their timestamps like this:
> How would I do this with an UPDATE statement (e.g.) in pgsql?
If you want ordered data use an ORDER BY clause in the select,
there is no other reliable way.
--
⚂⚃ 100% natural
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: Number timestamped rows
In-Reply-To: <j9at6c$7ro$2@reversiblemaps.ath.cx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox