On 2011-11-02, Jan Peters <petersjan(at)gmx(dot)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