My understanding of RDBMs: you will get all information as indicated by the query in an unsorted order. Sometimes you get the same order; sometimes you do not.
To ensure expected ordering you must use the ORDER keyword. Quoting Josué Maldonado <[EMAIL PROTECTED]>: > 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 [EMAIL PROTECTED] > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
