Re: Record order change after update

Clinging to sanity, josue(at)lamundial(dot)hn (Josué Maldonado) mumbled into her beard:
> 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?

Prevent what?

SQL returns unordered sets of data unless you specifically impose an
order using an ORDER BY clause.

Did PostgreSQL ignore your ORDER BY clause? If so, that would be a
problem worth reporting.

But if your query did not impose an ORDER BY clause, it is entirely
proper for the database engine to return data in whatever order it
finds most convenient.
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://cbbrowne.com/info/sap.html
"When people understand what Microsoft is up to, they're outraged."
-- Tim O'Reilly, President, O'Reilly & Associates