On Tue, Mar 02, 2004 at 04:12:05PM -0600, Josué Maldonado wrote: > 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?
Yes. > is there a way to prevent it? No. Use ORDER BY. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Los dioses no protegen a los insensatos. Éstos reciben protección de otros insensatos mejor dotados" (Luis Wu, Mundo Anillo) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
