Re: Record order change after update - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Record order change after update
Date
Msg-id 20040302221617.GC13876@dcc.uchile.cl
Whole thread Raw
In response to Record order change after update  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
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)

pgsql-general by date:

Previous
From: Josué Maldonado
Date:
Subject: Record order change after update
Next
From: Matt Davies
Date:
Subject: Re: Record order change after update