Franco Bruno Borghesi <franco@akyasociados.com.ar> writes:
> >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?
The paragraph you quoted above answers your question. Use ORDER BY if
you want a definite order out of a SELECT query.
-Doug