Re: Record order change after update

From the relational point of view, tuples in a relation are sets, and
sets have no ordering.
That's why you should never trust how tuples are ordered (on any
relational database, not just postgreSQL), and if you care about
ordering you should always use the ORDER BY clause.

On Tue, 2004-03-02 at 19:12, Josué Maldonado wrote:

> Hello list,
>
> After update a column on a table, that row goes to the top when I do a
> select from that table without any order, is that the expected behavior
> in postgresql? is there a way to prevent it?
>
> Thanks in advance.
>
> Josué Maldonado
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>