Clinging to sanity, [EMAIL PROTECTED] (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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
